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

267 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
wings9572724(None) 
dings76331401dings
kings105825571kings
lings67135771lings
pings85830881pings
rings65029171rings
sings65532701sings
swings104714451swings
tings65329211tings
wigs84931261wi_gs
winds95425611winds
wines85546861wines
wing86339231wing_
wingy126521031wingy
winks125325431winks
winos84625041winos
wins75949181win_s
wrings104012971wrings
zings154620891zings
agings86312672agings
ains46158892ain_s
awing96827322awing_
awnings11406712awnings
bangs85627782bangs
beings94613032beings
bigs76235032bi_gs
binds86627482binds
bines76946792bines
binge85125512binge
binges93923122binges
bingo86020092bingo
bingos95514792bingos
bins66548262bin_s
bints76130182bints
biogs85016112biogs
boings96416872boings
bongs87828422bongs
bowings133612002bowings
brings94618432brings
bungs85323862bungs
cigs75625112ci_gs
cines75239682cines
clings95716212clings
dangs75623212dangs
digs66036062di_gs
dines66449152dines
ding66940962ding_
dinge75627302dinge
dinges83825422dinges
dingo74720792dingo
dingus83611842dingus
dingy105721262dingy
dinks105927952dinks
dinos65428062dinos
dins56652052din_s
dints67431312dints
doings84913182doings
dongs76525812dongs
dungs75821972dungs
dwines105013102dwines
dyings11478132dyings
engs56121392_engs
fangs96224082fangs
figs85332652fi_gs
finds95424832finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849102fin_s
flings106715282flings
gangs76222582gangs
gigs66631192gi_gs
ginks104319562ginks
gins55543962gin_s
goings84911522goings
gongs74921612gongs
hangs95726732hangs
hinds96721482hinds
hinge95323452hinge
hinges105121032hinges
hins76448002hin_s
hints87330622hints
hongs95126202hongs
icings9428452icings
iggs66612672_iggs
inks86926502_inks
inns46920932_inns
ins35945612_in_s
jigs126524772ji_gs
jingo134615212jingo
jinks165019332jinks
jinns126013842jinns
jins115635022jin_s
kiangs11378362kiangs
kinas95626922kinas
kinds106221832kinds
kines95039142kines
king95933672king_
kinks84926092kinks
kinos96626152kinos
kins85747922kin_s
lawings113611472lawings
liangs74410592liangs
lines57054572lines
ling57447972ling_
linga66820822linga
lingas75116572lingas
lingo66022112lingo
lingy96925142lingy
links96430192links
linns56123332linns
linos55631502linos
lins47059062lin_s
lints57137192lints
longs65527062longs
lowings113710072lowings
lungs65223882lungs
lyings10488502lyings
miggs96311372miggs
migs76935332mi_gs
minas75434112minas
minds85427132minds
mines75651952mines
mingy115520182mingy
minis75432992minis
minks115829272minks
mints76834042mints
minus75223932minus
mowings13328482mowings
nines55937342nines
oinks94819912oinks
owing96222722owing_
pangs84628672pangs
pigs76634232pi_gs
pinas75434452pinas
pines76048862pines
ping75943602ping_
pingo87122712pingo
pingos95317672pingos
pinks115729382pinks
pins65558462pin_s
pints75936222pints
pongs85526342pongs
pungs85422222pungs
rigs55137602ri_gs
rinds64826152rinds
ring56541162ring_
rinks94827102rinks
rins46153202rin_s
rowings113710362rowings
rungs611819402rungs
sewings11369172sewings
signs65516322signs
sines55954822sines
sing57544182sing_
singe65731132singe
singes74326852singes
sinhs86719602sinhs
sinks95529182sinks
sins46755282sin_s
sinus55523852sinus
slings74618012slings
songs67725552songs
stings76220182stings
swigs96213662swi_gs
swing96124842swing_
swinge105614382swinge
swinges113413422swinges
swingy13489872swingy
swinks134610652swinks
tangs65028362tangs
things104914302things
tines54848422tines
ting56139922ting_
tinge64626632tinge
tinges74722342tinges
tins45251312tin_s
tints56030922tints
tongs65928472tongs
tungs65520632tungs
twangs10358102twangs
twigs96911172twi_gs
twines94717272twines
twinge104210402twinge
twinges11409452twinges
twins85118982twin_s
vangs96319602vangs
vigs85427282vi_gs
vinas85126342vinas
vines85137642vines
vinos84723072vinos
wags86140552w_ags
wains86930872wain_s
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452272wan_s
wants87932212wants
waxings18366452waxings
wends95822812wends
wens76337932wen_s
whangs13439722whangs
whigs125612642whigs
whines125120102whines
whinge134311542whinge
whinges143610632whinges
whins114922332whin_s
wicks144619362wicks
wides94832832wides
wifes114522562wifes
wig76740392wi_g_
wiggy134510732wiggy
wilds94818212wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
wimps125213802wimps
win66456302win__
wince105220882wince
winces114819112winces
winch135016662winch
wind85533862win_d
windy126118112windy
wine74953432win_e
wined94434182wined
winey115325432winey
winged114620832winged
winger104125442winger
wingers113921482wingers
winish124212272winish
wink116435032win_k
wino75933622win_o
winoes94317012winoes
winy107034332win_y
winze175014852winze
winzes184313052winzes
wipes104827082wipes
wires86034912wires
wirings113910112wirings
wis66552342wi__s
wises85633192wises
wisps105214182wisps
wiss75630552wi_ss
wists86728522wists
wites85536962wites
wits76044882wi_ts
wives115328922wives
wizes174723342wizes
wogs86531402w_ogs
wonks124818342wonks
wons74942042won_s
wonts87621542wonts
wrangs104611912wrangs
wring95920712wring_
wrongs10338932wrongs
wynds126310372wynds
wynns11517472wynns
wyns105717032wyn_s
yangs95618702yangs
yins75335132yin_s
zigs145422802zi_gs
zincs165312932zincs
zines145232652zines
zing145728622zing_
zingy186516132zingy
zins135735012zin_s

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 Filter178691538000.313570897.8
2DLD Change Limit538002671.64032804.9
3Display Results2672670.0763513.2
 (SQL Overall)1786912672.02988068.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.