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

101 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
dishelm133583(None) 
dishelms1444721dishelms
dished114318712dishe_d
dishelmed1645092dishelmed
dishes104622652dishe_s
dispel9310322dispel_
dispels10310502dispels
bioherm1434653bioherm
bushel114513943bushel_
bushels124110713bushels
dashed115920563dashe_d
dasheen1136393dasheen
dasher104318983dashe_r
dashers115016863dashers
dashes106124983dashe_s
diadem1037583diade_m
diastem10318043diaste_m
diel59034603di__el_
diesel74410403diesel_
diesels8429143diesels
direly10311563di_rely
dirham12378273dirh_am
disable10516433disable
disarm9310473dis_arm
disced104914653disce_d
discept12310623discept
discern1038493discern
diseur738843dis_eur
dish86328333dish___
dishelming1745273dishelming
disherit12412523disherit
dishevel1564703dishevel
dishevels1653633dishevels
dishful1455433dishful
dishfuls1554313dishfuls
dishier113613403dishier
dishiest12313683dishiest
dishing124017103dishing
dishpan13105523dishpan
dishrag1246273dishrag
dishy125712353dish__y
disject17268673disject
disked125015763diske_d
dismal92412243dismal_
dismals102010243dismals
disme85716243disme__
dismes95617673disme_s
dispend11289413dispend
disseat83816923disseat
dissect103614133dissect
dissed85220183disse_d
dissent84018683dissent
dissert83720693dissert
disses75225963disse_s
distal73615773distal_
distend93312073distend
distent84120853distent
distil73616433distil_
distill83011323distill
distils83015803distils
ditheism1446053ditheism
dither104417683dithe_r
dithers114016153dithers
dithery14318943dithery
dossel74813643dossel_
dossels85511613dossels
fished134316313fishe_d
fisher124917143fishe_r
fishers134714723fishers
fishery16397733fishery
fishes125221343fishe_s
fisheye1644773fisheye
fishily1637643fishily
helm95530023___helm
hisself1335913hisself
isohel935483_isohel_
isohels1035393_isohels
listel64214743listel_
listels74212433listels
lithely1356643lithely
misdeem12217873misdeem
mishear1238393mishear
misrely12319613misrely
missel85216523missel_
missels94614813missels
misterm114314513misterm
pished124817063pishe_d
pisher114317753pishe_r
pishers123815753pishers
pishes114722103pishe_s
shelf115221113__shelf
shell84424123__shell
skelm114211293__skelm
unhelm1136863_unhelm
unshell1047113unshell
whelm134611983__whelm
wisely122711713wis_ely
wished134417513wishe_d
wisher123617063wishe_r
wishers133215213wishers
wishes124920953wishe_s

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271016.97019229.1
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.40624127.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.