Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “earshots” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
earshots114662(None) 
earshot10410831earshot_
airshots1145942airshots
eyeshots1453372eyeshots
airshot1059493airshot_
airshows1444163airshows
archons12311583_archons
argots74116033_ar_gots
arhats9312973_ar_hats
arshins10312573_arshins
arsons63917213_ars_ons
ascots85312513_a_scots
barhops14288113bar_hops
borshts1266543borsh_ts
bowshots1645103bowshots
carhops14329703car_hops
carrots9714623car_rots
cashoos12310793ca_shoos
darshans1286543darshans
dashpots1444193da_shpots
eardrops1165303eardrops
earldoms1144223earldoms
earlships1444773earlships
earnests837853earnests
earphone1348253earphone
earphones1448393earphones
earstone848603earstone
earstones948523earstones
earthnuts1252943earthnuts
earths95014593earth__s
earthsets1244123earthsets
easts57530323ea_s__ts
enroots738713enr_oots
erasions8310983erasions
ergots74512373e_r_gots
escots84211743e__scots
eyeshot1386553eyeshot_
eyespots1362973eyespots
gearshifts1751663gearshifts
gunshots1244373gunshots
hardhats1546833hardhats
haricots1347333haricots
harlots103413293har_lots
harshens1437603harshens
harshest14310193harshest
harslets1137833harslets
hotshots1455513hotshots
karsts106012943kars__ts
manihots13126443manihots
markhors1745393markhors
marmots11311513mar_mots
marplots1245633marplots
marshals1337783marshals
marshes123615373marsh_es
mascots113910343ma_scots
nearshore1253463nearshore
overshots1546623overshots
parashot13410143parashot_
parashoth1753973parashoth
parrots9312743par_rots
parsons93516873pars_ons
potshots1346283potshots
rimshots1343883rimshots
sarsnets836783sarsnets
shots84730853___shots
snapshots1443133snapshots
tarots66422993tar__ots
teashops1345733tea_shops
upshots1235193_upshots
warships1647553warships
warthogs1544833warthogs
washouts1445903wa_shouts

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit146162727.61019206.6
3Display Results72720.0302400.0
 (SQL Overall)178691728.06322161.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.