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 “standish” 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.

129 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
standish123854(None) 
blandish1497002blandish
brandish1469022brandish
sandfish1556682s_andfish
stablish1348342stablish
standing103413632standing
standishes1445712standishes
stands75118052stand_s_
starfish1438082starfish
stonish10410652ston_ish
tannish101610572_tannish
tundish1137282_tundish
astonish1148453aston_ish
baldish1339503_baldish
banish111416043_ban_ish
blondish1476173blondish
caddish143810123_caddish
clannish1345263clannish
crankish1736513crankish
dandyish1644723_dandyish
danish101513793_dan_ish
establish1444743establish
evanish1337653evan_ish
faddish15359003_faddish
fiendish1544033fiendish
jadish17319903_ja_dish
kaddish16317973_kaddish
laddish12299723_laddish
maddish14289483_maddish
maidish13239553_maidish
mannish121710693_mannish
orangish1246543orangish
outlandish1452853outlandish
panfish15229973_panfish
planish12412053plan_ish
prankish1737023prankish
radish103516913_ra_dish
rankish14510383_rankish
roundish1246253roundish
sadis64930853s_a_dis_
sadism94113493s_a_dism
sadist74221353s_a_dist
saltish10312163s_altish
sandhis1139993s_andhis_
sandier84017843s_andier
sandiest93218683s_andiest
sanding93520603s_anding
sands65228583s_and_s_
sandwich1743653s_andwich
satanism1039673satan_ism
satanist8313363satan_ist
sawfish1637683s_awfish
scampish1744893scampish
scandia1038063scandi_a
scandias1137863scandias
scandic1237003scandi_c
scandium1365693scandium
shandies122714103shandies
shantih13309643shanti_h
shantihs14276213shantihs
shantis103313103shantis_
slapdash1442393slapdash
slavish1338233sla_vish
smallish1346573smallish
snappish1545233snappish
sparkish17276973sparkish
stades74626243sta_des_
stadia7312143sta_di_a
stadias8411113sta_dias
stadium1038073sta_dium
staidest939803staidest
stances93715963stances_
stanch113812373stan__ch
stand65923283stand___
standard1046253standard
standby1334423stand_by
standbys1443203standbys
standee83514513stand_ee
standees93310143standees
stander84316163stand_er
standers93514303standers
standfast1343913standfast
standings11257153standings
standoff1543993standoff
standoffish2161343standoffish
standout948663standout
standpat1145723standpat
standpipe1443343standpipe
standup1034353stand_up
standups1143963standups
stanes64933403stan_es_
stanging104013653stanging
stangs75018163stan_gs_
stanine73417073stan_ine
staning83922243stan_ing
stanks104917703stan_ks_
stannic936663stanni_c
stannite847583stannite
stanols739733stanols_
stanzas1636363stanzas_
stardust946093stardust
stash84916973sta___sh
stasis63116873sta_sis_
statism9412283sta_tism
statist7317723sta_tist
steepish1375823steepish
stiffish1745243stiffish
stockish17186043stockish
stonefish1544063stonefish
stoutish1145903stoutish
stranding1149653stranding
strands83711953strand_s_
strongish1344923strongish
studfish1544523studfish
stylish13197443st_ylish
sunfish1338883s_unfish
swainish1444753swainish
swampish1844173swampish
swinish1347203swin_ish
tallish103313583_tallish
tanist6324593_tan_ist
tarnish101611873_tarnish
tartish101512633_tartish
toadish1139063_toadish
tonish93415903_ton_ish
tonnish10149093_tonnish
tsadis7429133tsa_dis_
vanish121513213_van_ish
zanyish2235903_zanyish

Search took 7 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.1561145455.1
2DLD Change Limit1461621296.56322270.6
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.76526414.0
 
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.