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

122 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
godwit113751(None) 
godwits1234131godwits
godet7530042god_et
adit56443653_ad_it
admit8319493_admit
audit62527883aud_it
bedsit9312843bedsit
bodkin1338923bodkin
coadmit1247833coadmit
codeia94112193codeia
codein94916723codein
codlin94516443codlin
coedit9316243coedit
comfit133112423comfit
commit124016703commit
conduit10713083conduit
confit113316403confit
dimwit1237953dimwit
dit47071333__d_it
doit56347853__doit
dowie94721143do_wie
duit56241583__duit
edit54934863_ed_it
forrit91916623forrit
gaddi85211633gaddi_
gaddis94211373gaddis
gadget93616183gadget
gadi66329723gad_i_
gadid85517383gad_id
gadis74825293gad_is
gadoid9310463gadoid
gait56150193g__ait
gambit114714213gambit
gaslit7513503gaslit
geodic1048003geod_ic
git46266053g___it
goalie7413163goalie
goat56250833go__at
gobbet114214443gobbet
goblet93219483goblet
goblin939503goblin
god57449793god___
goddam1145163goddam
godded104811803godded
godding113911943godding
godetia945353godetia
godets8410933godets
godlier938893godlier
godliest1039453godliest
godlike1387563godlike
godlily1235343godlily
godling103513403godling
godly104913293god_ly
godown1136033godown
godowns1234673godowns
gods65438043god__s
godship1445083godship
godson857383godson
goglet84618583goglet
goldest92411173goldest
gomuti936553gomuti
gonia64117533go_nia
gonif94320923go_nif
goodie83613993goodie
goodwife1642393goodwife
goodwill1342863goodwill
goonie73615563goonie
gopik1257533go_pik
gordita945093gordita
gorget87123863gorget
gossip946433gossip
got49870443go___t
gothic1237793gothic
gothite1146403gothite
gout56646003go__ut
gowan95415743go_wan
gowd96519983go_w_d
gowds105814043go_wds
gowk125516473go_w_k
gowks136011953go_wks
gown85724073go_w_n
gowns95115103go_wns
goyim1148603go_yim
grit55247243g__rit
hobbit132810543hobbit
hoddin11369943hoddin
howdie13349733howdie
iodic84816753iod_ic
iodid74315533iod_id
iodin64419353iod_in
modest93818453modest
modi76826313mod_i_
nitwit938593nitwit
nodi56626743nod_i_
nowt78833753no_w_t
obit66837083_o_bit
oddity1135243_oddity
odic74920573_od_ic
odist6421913_odist
omit65337373_o_mit
orbit73622063_orbit
outwit93014593outwit
peewit111110903peewit
pewit104622793_pewit
podia8415283pod_ia
podite93315353pod_ite
posit75833333po_sit
rodent7519243rodent
sobeit8315363sobeit
sodic84917493sod_ic
soffit1237883soffit
tidbit938493tidbit
toit46353063to__it
tomtit8413853tomtit
towie85821873to_wie
twit76329063__twit
unwit84417523_unwit
vomit102622573vo_mit
wit66563773___wit
worrit92313313worrit
yowie114616453yo_wie
zowie174313843zo_wie

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 Filter1786911127160.813219792.1
2DLD Change Limit1127161226.81316544.3
3Display Results1221220.0304066.7
 (SQL Overall)1786911227.65623340.0
 
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.