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

250 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
zing14572862(None) 
ding66940961ding
king95933671king
ling57447971ling
ping75943601ping
ring56541161ring
sing57544181sing
ting56139921ting
wing86339231wing
zig136931911zi_g
zin125643781zin_
zinc156819101zinc
zine137036161zine
zings154620891zings
zingy186516131zingy
zins135735011zins
acing87429152acing
adzing174110012adzing
aging77026352aging
ahing98928352ahing
ain37579102ain_
ains46158892ains
aping87327232aping
awing96827322awing
axing138521372axing
azine146721412azine
bang74837012bang
being84920502being
big67345732bi_g
bin56658652bin_
bind76234522bind
bine66650872bine
binge85125512binge
bingo86020092bingo
bins66548262bins
bint67355052bint
biog76122332biog
boing84725552boing
bong75633412bong
bring85528502bring
bung75730632bung
cig67036192ci_g
cine66242952cine
cling86424672cling
cuing85420192cuing
dang65131552dang
dazing175516512dazing
dig57544482di_g
din46459472din_
dine55555342dine
dinge75627302dinge
dingo74720792dingo
dings76331402dings
dingy105721262dingy
dink97137812dink
dino56036762dino
dins56652052dins
dint56759062dint
doing74923582doing
dong66031652dong
dozing174214192dozing
dung66328432dung
dying105316032dying
eking106614992eking
eng46726782_eng
exing136016812exing
eying96117922eying
fang85432562fang
fazing194418642fazing
fig76242842fi_g
fin66458042fin_
find87532612find
fine75147962fine
fink117532132fink
fino76034702fino
fins75849102fins
fling97023512fling
fuzing194110642fuzing
gang66031982gang
gazing174717172gazing
gig56040762gi_g
gin46055762gin_
gink97129532gink
gins55543962gins
going75218492going
gong66827192gong
hang85535562hang
hazing194218552hazing
hin67559572hin_
hind85529762hind
hinge95323452hinge
hins76448002hins
hint77455752hint
hong85833952hong
hung86126352hung
hying126514742hying
icing86017752icing
igg57116802_igg
in28150872_in_
ink76433642_ink
inn36727442_inn
ins35945612_ins
iring66025422iring
jig115633522ji_g
jin106443942jin_
jingo134615212jingo
jink156227212jink
jinn115420252jinn
jins115635022jins
jinx185516582jinx
kiang104811362kiang
kin76353982kin_
kina85632012kina
kind96128572kind
kine85643442kine
kings105825572kings
kink76034412kink
kino86233632kino
kins85747922kins
lang56637392lang
lazing164821472lazing
liang64914412liang
lin37967382lin_
line46965582line
linga66820822linga
lingo66022112lingo
lings67135772lings
lingy96925142lingy
link86943452link
linn46034602linn
lino46343382lino
lins47059062lins
lint416266242lint
liny78141332liny
long56933342long
lung55732492lung
lying95717452lying
mazing184418972mazing
mig65646092mi_g
migg85716812migg
mina65136932mina
mind75434392mind
mine67256182mine
mingy115520182mingy
mini65634572mini
mink106636542mink
mint66758072mint
minx137723362minx
nine45842182nine
ohing96018812ohing
oink85429352oink
oozing163812202oozing
oping86322412oping
owing96222722owing
pang75336302pang
pig65744982pi_g
piing85218832piing
pin57066732pin_
pina65842642pina
pine67755722pine
pingo87122712pingo
pings85830882pings
pink107039392pink
pins65558462pins
pint66963182pint
piny911838362piny
pong76231142pong
pung75429632pung
rang56939172rang
razing164524542razing
rig46748132ri_g
rin36663192rin_
rind56535612rind
rings65029172rings
rink87737002rink
rins46153202rins
ruing67221052ruing
rung56429982rung
sang55441242sang
sign55523062sign
sin36265902sin_
sine46560632sine
singe65731132singe
sings65532702sings
sinh76238052sinh
sink86640152sink
sins46755282sins
sizing163616442sizing
sling66028802sling
song55133672song
sting65330242sting
suing65026362suing
sung55832172sung
swing96124842swing
tang56138692tang
thing96622982thing
tin36362182tin_
tine45855142tine
tinge64626632tinge
tings65329212tings
tins45251312tins
tint46758872tint
tiny76134642tiny
tong56434362tong
tung55328172tung
tying96019842tying
using66317962using
vang84926052vang
vig75637532vi_g
vina76331812vina
vine75643692vine
vino76128442vino
viny106025962viny
vying125111812vying
wig76740392wi_g
win66456302win_
wind85533862wind
wine74953432wine
wings95727242wings
wingy126521032wingy
wink116435032wink
wino75933622wino
wins75949182wins
winy107034332winy
wring95920712wring
yang85626082yang
yin67648742yin_
yins75335132yins
zag137539472z_ag
zany167316992zany
zein135620602zein_
zeins144715392zeins
zigs145422802zigs
zill135727622zill
zincs165312932zincs
zincy195413512zincy
zineb165614142zineb
zines145232652zines
zinged174414622zinged
zinger163816702zinger
zinky215314812zinky
zip146636232zi_p
zips155723802zips
zit126050002zi_t
ziti136022382ziti
zits136030302zits
zona136321962zona
zone135231082zone
zoning162914332zoning
zonk175018622zonk

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 Filter178691298720.546327272.9
2DLD Change Limit298722501.65618038.6
3Display Results2502500.1102272.7
 (SQL Overall)1786912502.31277288.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.