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

149 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
igg5711680(None) 
egg56918671egg
gig56040761gig
iggs66612671iggs
migg85716811migg
ag311067462_ag
aga410447232aga
age47154332age
ago48845522ago
agog68019002agog
ags47551662ags
bag67059222bag
beg65944132beg
big67345732big
biggy124413132biggy
bigs76235032bigs
biog76122332biog
bog67852412bog
bug65340742bug
cig67036192cig
cigs75625112cigs
cog69552902cog
dag57753012dag
dig57544482dig
digs66036062digs
ding66940962ding
dog57449752dog
dug58138692dug
eggs66516152eggs
eggy96611852eggy
ego46726052ego
eng46726782eng
erg45531072erg
fag76852362fag
fig76242842fig
figs85332652figs
fog76945562fog
fug76234512fug
gag57753632gag
gib66443542gib
gid57047282gid
gie47149552gie
giga66720952giga
gigs66631192gigs
gin46055762gin
gip67645372gip
git46266062git
go38748742_go
hag77255742hag
high116619932high
hog78049062hog
hogg96617532hogg
hug76037362hug
ice56737252ice
ich86227752ich
ick97329332ick
icy86322132icy
id38941852i_d
ids47535482ids
if57239962i_f
iff96730402iff
ifs67124252ifs
igged86012762igged
iglu510814782iglu
ilk78325312ilk
ill37437102ill
imp76626982imp
in28150872i_n
ink76433642ink
inn36727442inn
ins35945612ins
ion36051032ion
ire36943182ire
irk76426372irk
is27048222i_s
ism56322392ism
it28455692i_t
its35538842its
ivy96317452ivy
jag116542712jag
jagg136115312jagg
jig115633522jig
jiggy17549142jiggy
jigs126524772jigs
jog117438312jog
jug115529542jug
keg86432552keg
king95933672king
lag47862122lag
leg46446112leg
ling57447972ling
log46252682log
lug46138062lug
mag67956482mag
meg66040952meg
mig65646092mig
miggs96311372miggs
migs76935332migs
mog66949672mog
mug65837692mug
mugg86316012mugg
nag46450812nag
neg47237342neg
nigh85220672nigh
nog46847312nog
nogg65115942nogg
peg65843062peg
pig65744982pig
piggy124011432piggy
pigs76634232pigs
ping75943602ping
pug65337182pug
rag45761322rag
ragg65622692ragg
reg46146492reg
rig46748132rig
rigs55137602rigs
ring56541162ring
rug46039152rug
sag46163402sag
seg45544882seg
sigh85625902sigh
sign55523062sign
sing57544182sing
tag47259502tag
teg45741622teg
tegg65315922tegg
ting56139922ting
tog410255042tog
tug45937402tug
ugh76520682ugh
veg76931062veg
vig75637532vig
viga85622972viga
vigs85427282vigs
vug76127412vug
vugg95612712vugg
wag76451752wag
wig76740392wig
wiggy134510732wiggy
wigs84931262wigs
wing86339232wing
wog76242732wog
yag76947732yag
yegg96511792yegg
zag137539472zag
zig136931912zig
zigs145422802zigs
zing145728622zing

Search took 2 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 Filter178691140840.530337152.8
2DLD Change Limit140841490.73619135.9
3Display Results1491490.0602483.3
 (SQL Overall)1786911491.326134759.4
 
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.