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

126 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
godsend108404(None) 
godsends11113351godsends
godded104811802godde_d
godhead1334762godhead
godson857382godson_
godsons966662godsons
goosed86817032goose_d
addend9458453_addend
boded95124963bod_e_d
bodied103814583bodie_d
bookend14396643bookend
bossed94816533bosse_d
boused95322883bouse_d
bowsed125715973bowse_d
codded114515303codde_d
coded95433183cod_e_d
coden86128543cod_en_
codens94821013cod_ens
commend144010183commend
compend144010303compend
consent93723113consent
contend103511893contend
dodged107514693dodge_d
dosed76626913do_se_d
dossed84516633dosse_d
doused84821163douse_d
dowsed115015013dowse_d
forfend1435413forfend
gadded103913173gadde_d
gassed85217633gasse_d
genseng933983genseng
ginseng933433ginseng
glossed94410073glosse_d
goaded94913713goade_d
goaled85014363goale_d
goateed9307063goateed
gobbed124613883gobbe_d
goddess1035263goddess
godding113911943godding
godet7530043god_e_t
godets8410933god_ets
godheads1443983godheads
godhood1345143godhood
godless938403godless
godling103513403godling
godown1136033godown_
godowns1234673godowns
gods65438043gods___
godship1445083godship
golden84411153golden_
golfed11569763golfe_d
gonged97115913gonge_d
goodmen1135623goodmen_
goofed114911383goofe_d
goose65925903goose__
gooses75723063goose_s
goosey105913513goose_y
goosing93314083goosing
gored75227083go_re_d
gorged95016983gorge_d
gorhen1038903gorhen_
gorhens1137183gorhens
gormand1157453gormand
gormed105013833gorme_d
gorse65926813gorse__
gorses74723293gorse_s
gossan747233gossan_
gossans836783gossans
gotten73410113gotten_
gouged96214593gouge_d
gowaned1235763gowaned
gowned114410133gowne_d
grossed93812253grosse_d
groused94712833grouse_d
guised84612173guise_d
hodden113811453hodden_
hoddens12378803hoddens
hoised105117433hoise_d
horsed105321083horse_d
hosed95830983ho_se_d
hosen85623883ho_sen_
housed105624103house_d
iodised9329243iodise_d
loden66621143lod_en_
lodens74315063lod_ens
lodged913815713lodge_d
loosed75520893loose_d
loosen66615963loosen_
loosened945453loosened
loosens716310963loosens
loused74822913louse_d
missend104411373missend
mossed94818893mosse_d
moused94423303mouse_d
nodded94012123nodde_d
noised75416233noise_d
noosed75018013noose_d
nosed65524553no_se_d
offend13365663_offend
owsen84210193_owsen_
podded115012713podde_d
poised94918473poise_d
portend103411193portend
posed85828413po_se_d
resend75016773_resend
rodded93713703rodde_d
rodent7519243rod_ent
rodmen939713rodmen_
rodsmen1035833rodsmen_
roosed75621593roose_d
rosed65930343ro_se_d
roused75426443rouse_d
send55237293___send
sodded94113303sodde_d
sodden84011513sodden_
soddened1144643soddened
soddens9348413soddens
soused74822983souse_d
sudsed83911373sudse_d
tossed74215223tosse_d
toused74122013touse_d
upsend9356883_upsend
worsen95513873worsen_
worsened1236053worsened
worsens104610263worsens
yodled11389653yodle_d

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.403443402.0
2DLD Change Limit1340271266.76619808.9
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.21524766.6
 
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.