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

170 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
dentists93926(None) 
dentist8316741dentist_
centrists11410232centrists
deists74916432de__ists
delists84414172de_lists
demotists1247322demotists
dentils84115582denti_ls
dentines93418402dentines
dentins83419222denti_ns
dentistry1342492dentistry
denturists1145352denturists
desists83611722de_sists
detentists1145502detentists
detests83711742de_tests
duettists1043042duettists
enlists749392_enlists
entwists1156142_entwists
leftists11235512leftists
lentisks1244412lentisks
tennists8297792tennists
adenitises1145723adenitises
artists74215593_artists
autists73814853_autists
baptists1236723baptists
bemists113410703be_mists
betises94816123be_tises
bundists1145383bundists
cellists1038563cellists
centeses1079443centeses
centesis1058143centesis
centiles103615813centiles
centimes124012613centimes
centimos12507323centimos
centrisms1348053centrisms
centrist10314863centrist_
chutists1335583chutists
consists10310593consists
contests103413383contests
cultists10107633cultists
dadaists1045583dadaists
debits94214503de_bi_ts
deceits102810883decei_ts
defeatists1443423defeatists
defrosts1244833defrosts
deftest112611713deftest_
degusts936063de_gusts
deisms94411043de__isms
deist64633593de__ist_
deities82621923deiti_es
deixises1635693deixises
delicts104012253de_licts
delist74625053de_list_
demasts1089223de_masts
demises103719563de_mises
demits94918073de_mi_ts
demonists1248703demonists
demotist11311843demotist_
denials84114133den_ials
deniers84515183den_iers
denies74729643den_i_es
denims95214323den_i_ms
densest83112473densest_
density1137583densi_ty
dentals83915393dent_als
dentate8315153dent_ate
denticle1137773denticle
denticles1237753denticles
dentil74017883denti__l
dentiled1039743dentiled
dentin73919573denti__n
dentinal939503dentinal
dentine83320243denti_ne
denting94422183denti_ng
dentistries1253423dentistries
dents65031803den___ts
dentures9312453dentures
denturist1048463denturist_
depaints1136643depaints
depicts12358463de_picts
deposits1138843deposits
dermises112512023dermises
derrises93012783derrises
desist74818813de_sist_
despises1139433despises
destines93619663destines
detects104011093de_tects
detentist1049323detentist_
detents83615153de_tents
detest74122843de_test_
deticks1437353de_ticks
devests114410473de_vests
devises114116763de_vises
dialists9411413dialists
diarists9410363diarists
dualists958243dualists
duelists966003duelists
duellists1053753duellists
duettist945513duettist_
dynamists1544093dynamists
dynasts1155103dyn_asts
egoists887073_egoists
egotists937063egotists
elitists848543elitists
encysts1244313_encysts
enlist6417043_enlist_
entases72816273_entases
entasis73012573_entasis
entices91616333_entices
entires71517783_entires
entity9312053_enti_ty
entrusts847113_entrusts
entwist1048803_entwist_
exists134710913_e_xists
fantasts1147113fantasts
feists94915313fe__ists
feudists1244463feudists
flutists11256413flutists
genoises939253genoises
gentians937563gentians
gentiles93713523gentiles
heists96814633he__ists
henbits12177003henbi_ts
idealists1047223idealists
identity1245373identi_ty
insists739083_insists
intwists1145593_intwists
leftisms13235243leftisms
leftist10279353leftist_
legists899593le_gists
lentils73912973lenti_ls
lentisk1136063lentis_k
lutists73810273_lutists
mantises10317923mantises
mentalists12410483mentalists
mentions10312893mentions
metrists1039853metrists
monists93614783mon_ists
nepotists1145743nepotists
peltasts1035703peltasts
penises9318193pen_ises
pentoses10312893pentoses
persists1049183persists
pietists1038323pietists
plenists1038253plen_ists
protists10313363protists
realists83014843realists
reenlists946263reenlists
relists73817053re_lists
renests74014213ren_ests
rentiers83311763rentiers
resists74414923re_sists
retests73813853re_tests
retints74717013re_tints
retwists1135603retwists
revuists1135153revuists
scientists1244963scientists
semitists1148183semitists
sennits73811283senni_ts
sentients948463sentients
sentimos10407423sentimos
sexists14267673se_xists
statists8310163statists
tanists7313653tan_ists
tennises82810133tennises
tennist72813113tennist_
tenorists948193tenorists
tentiest82115613tentiest_
untwists1144623_untwists
vegetists1344483vegetists
verists103613673ve_rists

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.453394461.4
2DLD Change Limit1461621706.65621959.4
3Display Results1701700.0602833.3
 (SQL Overall)1786911707.16924925.5
 
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.