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

136 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
verditer123622(None) 
verditers1344991verditers
nerdier83110362nerdi_er
verderer1245372verderer
verier94620962ver_i_er
verite94323442ver_ite_
verites103822262ver_ites
vernier102711272verni_er
adroiter946193adroiter
aerier64823153aer_i_er
arbiter939933_arbiter
averter102410553aver__ter
beadier103513913beadi_er
bendier103111413bendi_er
bruiter93710633_bruiter
cerite84724873cer_ite_
cerites94823433cer_ites
cordite10315263cordite_
cordites11314633cordites
credited1238253credited
creditor1145903creditor
curdier103312623curdi_er
deedier93011593deedi_er
derider93214973der_ider
deriver114213913der_iver
dernier83011943derni_er
edited83913673_e_dited
editor738663_e_ditor
eerier64320023eer_i_er
endite73817593_endite_
endited93512913_endited
endites83717063_endites
erecter93113393_erecter
erudite838483_erudite_
exciter1637753_exciter
fernier103110823ferni_er
ferreter1136543ferreter
ferrite103312753ferrite_
ferrites112312833ferrites
fruiter10309683_fruiter
germier10309543germi_er
hardier114721543hardi_er
headier113212953headi_er
herbier1239593herbi_er
herder104516463herd__er
heritor10310563her_itor
inditer83514233_inditer
jerkier18407273jerki_er
kernite1159473kernite_
kernites1269113kernites
lardier83518343lardi_er
leadier83212723leadi_er
merited10313853mer_ited
merrier92612303merri_er
needier84010623needi_er
nervier10298843nervi_er
orbiter937853_orbiter
overbite13312083overbite_
overbites14310983overbites
overdoer12128713overd_oer
overdyer15125453overd_yer
overeater12312483overeater
overedited1547213overedited
overwater1538073overwater
overwinter1644443overwinter
perdie94718513perdi_e_
peripter1278753peripter
perkier133813123perki_er
perlite9317323perlite_
perlites10316363perlites
permitter1345963permitter
persister1146833persister
perter84422283per__ter
readier83117423readi_er
reciter94117263re_citer
recruiter1144873recruiter
reedier83815303reedi_er
reedited10310083reedited
requiter17168643requiter
reuniter838323reuniter
rewriter1137923rewriter
sedater83713633se_dater
seedier83513633seedi_er
servicer1335263servicer
servitor1145063servitor
straiter8311783straiter
tardier859719993tardi_er
tergite8311003tergite_
tergites9310543tergites
termite9313893termite_
termites10313693termites
terrier73414963terri_er
triter65120593_tr_iter
varier94619353var_i_er
vealier102712173veali_er
veiler93814353ve__iler
veiner94514753ve__iner
veinier10269583veini_er
veliger1137313ve_liger
velites103417303ve_lites
vender103418423vend__er
venter94218723ve__nter
verbile1249863verbile_
verbiles1338923verbiles
verboten1344313verboten
verderers1344843verderers
verderor1243203verderor
verdict1339583verdi_ct
verdicts1446013verdicts
verdin103113023verdi__n
verdins112812333verdi_ns
verdure11287773verdure_
verdured13255763verdured
verdures12247753verdures
verger104315703ver__ger
verifier14159203verifier
veritas103012753ver_itas
verities111418043ver_ities
verity123714853ver_it_y
verniers11227843verni_ers
vernixes1836053vernixes
verser94516963ver__ser
versifier15156533versifier
versine102515173versine_
versines112213823versines
verste94515633ver_ste_
verstes104014283ver_stes
vertex1637373ver__tex
vertices13612283vertices
vetiver1336103ve_tiver
vetter93417643ve__tter
visiter1038863v_isiter
vomiter1237953v_omiter
weedier113810623weedi_er
wordier112511213wordi_er
writer94416513_wr_iter

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.436409841.7
2DLD Change Limit1461621367.90618487.5
3Display Results1361360.0462956.5
 (SQL Overall)1786911368.38821303.2
 
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.