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

234 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
undotted104852(None) 
unpotted11108391unpotted
bedotted1234982bedotted
dotted84717522__dotted
knotted12357232kn_otted
unadopted1344562unadopted
unbitted1138212unbitted
unbolted1179322unbolted
unbooted1188772unbooted
unbottled1244152unbottled
uncoated11314962uncoated
undated93118462und_ated
undented102313952undented
undocked16277632undocked
undoubted1344462undoubted
unfitted1238162unfitted
ungotten944532ungotten
unhatted1238182unhatted
unknotted1443622unknotted
unletted9310312unletted
unmatted1138292unmatted
unnoted8311362unno_ted
unpitted1148622unpitted
unposted1159432unposted
unrooted9810512unrooted
unsorted9312512unsorted
unspotted1244932unspotted
unwetted1238122unwetted
unwitted1237542unwitted
unwonted12248642unwonted
adopted1136253_adopted
allotted986873allotted
annotated1095613annotated
besotted1135843besotted
blotted103911833_blotted
clotted104011823_clotted
doated84118183__doated
doited85016633__doited
doted75227073__do_ted
dottel73610893__dottel
dotter74419343__dotter
endited93512913end_ited
endorsed1057203endorsed
endostea944953endostea
endowed1248173endo_wed
enrooted977433enrooted
garotted1066193garotted
gavotted1363343gavotted
hotted104319943__hotted
indebted12246873indebted
indented101811733indented
indicted1249203indicted
indited93515023ind_ited
indorsed1066123indorsed
indowed1237443indo_wed
inducted1237273inducted
ingoted939183ingo_ted
inputted1134663inputted
insetted9249023insetted
intorted9310123intorted
jotted143615173__jotted
knitted12337423kn_itted
knotter11317643kn_otter
knouted12416773kn_outed
lotted74222403__lotted
netted74118713_n_etted
notated82713663_n_otated
noted65123843_n_o_ted
nutted74316973_n_utted
plotted104612373_plotted
potted94624013__potted
repotted1139283repotted
rotted74524433__rotted
shotted113912403_shotted
slotted84613883_slotted
snooted84213283sn_ooted
snorted83813493sn_orted
snouted84311343sn_outed
sotted74121403__sotted
spotted103713143_spotted
stotted83511423_stotted
sundowned1442683sundowned
swotted11398713_swotted
totted74319953__totted
trotted83711283_trotted
unabated11310133unabated
unabetted1244993unabetted
unaborted1245733unaborted
unacted10312733un_acted
unadapted1344653unadapted
unadmitted1443023unadmitted
unadorned1144123unadorned
unatoned939423unatoned
unbasted112510073unbasted
unbated103317733un_bated
unbathed1437223unbathed
unbelted1179333unbelted
unbitten1045213unbitten
unbitter1046173unbitter
unbobbed1234413unbobbed
unbodied1237263unbodied
unboiled112410373unboiled
unbonded12299763unbonded
unboned103014223unbo_ned
unbottle1044223unbottle
unbottles1143463unbottles
unbowed132610243unbo_wed
unboxed17249573unbo_xed
unbusted11258773unbusted
uncarted11312053uncarted
unclothed1545433unclothed
uncocked17248753uncocked
uncoded11312743unco_ded
uncoiled112512683uncoiled
uncoined111813023uncoined
uncombed1536323uncombed
uncooked15269113uncooked
uncooled112710633uncooled
uncorked152210403uncorked
uncounted1238523uncounted
uncrated11416313uncrated
undamped1445333undamped
undaunted1145453undaunted
undebated1338093undebated
undecked16238493undecked
undeleted1148063undeleted
undenied102211563undenied
underfed13311713underfed
undetected1444873undetected
undiluted1144903undiluted
undimmed1434113undimmed
undoctored1442923undoctored
undoer73113043undo__er
undoes73917403undo__es
undone7914253undo_ne_
undoubled1344233undoubled
undraped1239393undraped
undried92314613und_ried
undubbed1443523undubbed
undulated11310083undulated
undulled1036993undulled
undyed1138143und__yed
unedited10249833unedited
unfelted1279403unfelted
unfetter1136753unfetter
unfluted1237173unfluted
unfoiled12249723unfoiled
unfolded1338313unfolded
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
ungated92717213un_gated
ungifted13116833ungifted
ungowned1335183ungowned
unheated121514553unheated
unhooded13277873unhooded
unhooked16286743unhooked
unhoped13249353unho_ped
unhorsed1238833unhorsed
unhoused1238153unhoused
united74421543un__ited
unjoined16248443unjoined
unjointed1755583unjointed
unknitted1443703unknitted
unlisted9311153unlisted
unloaded1049533unloaded
unlobed10219743unlo_bed
unlocated1238383unlocated
unlocked15268383unlocked
unloosed9117523unloosed
unloved112310533unlo_ved
unmated103317023un_mated
unmelted1169183unmelted
unmitred1136843unmitred
unmolded1237453unmolded
unmolten1044933unmolten
unmoored1137333unmoored
unmounted1245903unmounted
unmoved13248903unmo_ved
unnoticed1243923unnoticed
unoiled82415483un_oiled
unowned1148813un_owned
unparted11310823unparted
unpitied1138793unpitied
unpointed1237153unpointed
unpoised1139183unpoised
unpolled1168943unpolled
unposed10711903unpo_sed
unquoted1836533unquoted
unrated82621553un_rated
unrented92413923unrented
unrested91914513unrested
unroasted1036623unroasted
unrobed102711213unro_bed
unrolled9610413unrolled
unroofed12106773unroofed
unroped102812113unro_ped
unrusted92310353unrusted
unsalted9510923unsalted
unsated83419933un_sated
unseated91317683unseated
unsettled1055213unsettled
unsifted12128773unsifted
unsoaked1338853unsoaked
unsoiled92412083unsoiled
unsolved1237833unsolved
unsoothed1344253unsoothed
unsoured9310063unsoured
unsowed112511053unso_wed
unstated91615813unstated
unstoned9311043unstoned
unsuited9310793unsuited
untasted92011573untasted
untented92613413untented
untested92612413untested
untied73720813un__tied
untilted9610893untilted
untitled978763untitled
untufted1236083untufted
ununited938683ununited
unvested122210223unvested
unvoiced14106303unvoiced
unwanted12249603unwanted
unwasted12259783unwasted
unwooded13207443unwooded
unwooed11229773unwo_oed
unworked16238503unworked
unyoked1567123unyo_ked
unzoned172310653unzo_ned
updarted1244313updarted
updated11369423upd_ated
uprooted1186393uprooted
wotted104115713__wotted

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.406440125.6
2DLD Change Limit1461622346.11023921.8
3Display Results2342340.0932516.1
 (SQL Overall)1786912346.60927037.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.