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 “doited” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

144 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
doited8501663(None) 
doated84118181doated
doiled84817291doiled
doted75227071do_ted
dotted84717521dotted
toited74016751toited
adopted1136252adopted
baited95319242baited
boated94221972boated
boiled95020952boiled
boite74426322boite_
boites84322702boites
bolted94617802bolted
booted94822732booted
cited84421952_cited
coated94927032coated
coifed124113062coifed
coiled95123932coiled
coined94523602coined
costed95623112costed
coted85033852co_ted
darted84620922darted
dated75530992d_ated
dauted84114932dauted
dawted11489682dawted
debited113311622debited
deiced104214482deiced
dented84120512dented
diced95824682d_iced
died66137852d_i_ed
dieted83115492dieted
diked115024682d_iked
dined76431992d_ined
dinted84419842dinted
dite55547552d_ite_
dites66339152d_ites
dived106321372d_ived
docked145018332docked
dodged107514682dodged
doffed14428502doffed
dogged106017702dogged
doit56347852doit__
doits66223672doit_s
doled75430912do_led
dolled83518072dolled
domed95423262do_med
donated93513862donated
donned85015742donned
doomed104113292doomed
doped95326712do_ped
dosed76626912do_sed
dossed84516632dossed
dote55442882do_te_
doter65428622do_ter
dotes65836692do_tes
dotier73917032dotier
dottel73610892dottel
dotter74419342dotter
doubted11307482doubted
doused84821162doused
dowed104632612do_wed
downed115314782downed
dowsed115015012dowsed
dozed165619352do_zed
dried75321382dri_ed
drifted12367952drifted
ducted104012122ducted
dueted84113592dueted
dunted84718502dunted
dusted83918372dusted
dwined114610212dwined
edited83913672edited
evited104013142evited
exited144712522exited
flited104616582flited
foiled104618402foiled
foined105915012foined
foisted113210602foisted
footed104418622footed
gaited84416922gaited
goiter74116202goiter
hoised105117432hoised
hoisted113411292hoisted
hooted104422652hooted
hosted105020342hosted
hotted104319932hotted
joined144613072joined
jointed15378502jointed
joisted15379172joisted
jolted143510632jolted
jotted143615172jotted
kited105120092_kited
lofted103811892lofted
loided83414022loided
loiter64619172loiter
looted74421112looted
lotted74222402lotted
louted74920692louted
moated94819002moated
moiled94318862moiled
molted94217472molted
mooted94120372mooted
noised75416232noised
noted65123842no_ted
oiled64429472_oiled
opted84914272_opted
outed65429062_outed
pointed103813982pointed
poised94918472poised
ported94223242ported
posited10511492posited
posted93722492posted
potted94624012potted
pouted94021392pouted
quoited1756402quoited
rioted73416372rioted
roiled74320052roiled
rooted75424002rooted
rotted74524432rotted
routed75624332routed
sited65130742_sited
skited114313472skited
soiled73822472soiled
sooted73922582sooted
sopited104211052sopited
sorted74523712sorted
sotted74121392sotted
spited94820442spited
suited74019422suited
toiled74420322toiled
tooted74620122tooted
toted64929482to_ted
totted74319952totted
touted74419742touted
united74421542united
voiced123910112voiced
voided114011132voided
vomited1337252vomited
voted93919142vo_ted
waited103819772waited
whited134814082whited
wited94727142_wited
wonted103213282wonted
wotted104115712wotted

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511442.43633887.9
3Display Results1441440.0463130.4
 (SQL Overall)1786911442.59268939.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.