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 “waterish” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
waterish1431053(None) 
waterier11312082waterier
wateriest12312232wateriest
waterily1438782waterily
watering122316312watering
waters95030632water_s_
winterish1546642winterish
actorish1349433actorish
amateurish1552053amateurish
asterisk1248673asterisk
asterism10413253asterism
batfish1558683bat_fish
bitterish1446133bitterish
cateress102311613cateress
catering112019903catering
caters85336503cater_s_
catfish1559023cat_fish
cattish12410723cat_tish
cavefish1974853cavefish
cherish15310463_cherish
daters74827373dater_s_
eateries8324313eateries
eaters65535953eater_s_
etherish1448273etherish
fairish1338993fa_irish
fattish1359263fat_tish
feverish1745413feverish
garish104516923ga__rish
gatecrash1571653gatecrash
gaters74728643gater_s_
haters94930403hater_s_
laterite8716333laterite
laterize17613293laterize
latish92416173lat__ish
liverish1447863liverish
marish114319053ma__rish
material10314103material
materiel10311253materiel
maters85032393mater_s_
naturism1047893naturism
naturist8410813naturist
oaters65029793oater_s_
parish115022353pa__rish
paters84935833pater_s_
perish114619063__perish
queerish2045313queerish
raters63936583rater_s_
ratfish1338773rat_fish
rattish10510823rat_tish
satirise8310683satirise
satirist8313503satirist
satoris7317253satoris_
taters64932203tater_s_
tigerish1246563tigerish
vaporish16246733vaporish
viperish1655893viperish
waders109120643wader_s_
wafering15208893wafering
wafers124316143wafer_s_
wafters134112813wafter_s_
wagering13219523wagering
wagers105122203wager_s_
waggish15207073wa_ggish
waifish1637703wa_ifish
waitering13310713waitering
waiters104218623waiter_s_
wakerife1843673wakerife
wakers134822493waker_s_
walers94824463waler_s_
wampish1777293wa_mpish
wanters104420093wanter_s_
warmish1538373wa_rmish
waspish1586923wa_spish
wasterie111211583wasteri_e
wasteries121115343wasteries
wasters104026593waster_s_
water84733313water___
waterage1248663waterage
waterbed1436443waterbed
waterbird1554503waterbird
waterbus1345863waterbus
waterdog1344453waterdog
watered113014953water_ed
waterer103314073water_er
waterers112312783waterers
waterhen1485303waterhen
wateriness1348073wateriness
waterings13229253waterings
waterjet1848293waterjet
waterless1238013waterless
waterlily1544343waterlily
waterline1249653waterline
waterlog1245043waterlog
waterloo1145723waterloo
waterman1397283waterman
watermen1377613watermen
watershed1644633water_shed
waterside1345803waterside
waterski1543223waterski
waterskis1643983waterskis_
watertight1773673watertight
waterway1745563waterway
watery123914493water__y
wavering152410543wavering
wavers125022473waver_s_
waxers164014303waxer_s_
wearish132310153w_earish
wettish1335963wet_tish
wheyish1944063w_heyish
whitefish2143073whitefish
whorish1636603w_horish

Search took 8 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.406440125.6
2DLD Change Limit1461621116.64022012.3
3Display Results1111110.0502220.0
 (SQL Overall)1786911117.09625181.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.