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
igg5711679(None) 
egg56918671egg
gig56040751gig
iggs66612671iggs
migg85716801migg
ag311067462_ag
aga410447232aga
age47154332age
ago48845522ago
agog68019002agog
ags47551662ags
bag67059222bag
beg65944132beg
big67345722big
biggy124413132biggy
bigs76235022bigs
biog76122322biog
bog67852412bog
bug65340742bug
cig67036182cig
cigs75625102cigs
cog69552902cog
dag57753012dag
dig57544472dig
digs66036052digs
ding66940952ding
dog57449752dog
dug58138692dug
eggs66516152eggs
eggy96611852eggy
ego46726052ego
eng46726782eng
erg45531072erg
fag76852362fag
fig76242832fig
figs85332642figs
fog76945562fog
fug76234512fug
gag57753632gag
gib66443532gib
gid57047272gid
gie47149542gie
giga66720942giga
gigs66631182gigs
gin46055752gin
gip67645362gip
git46266052git
go38748742_go
hag77255742hag
high116619922high
hog78049062hog
hogg96617532hogg
hug76037362hug
ice56737242ice
ich86227742ich
ick97329322ick
icy86322122icy
id38941842i_d
ids47535472ids
if57239952i_f
iff96730392iff
ifs67124242ifs
igged86012762igged
iglu510814782iglu
ilk78325302ilk
ill37437092ill
imp76626972imp
in28150862i_n
ink76433632ink
inn36727432inn
ins35945602ins
ion36051022ion
ire36943172ire
irk76426362irk
is27048212i_s
ism56322382ism
it28455682i_t
its35538832its
ivy96317442ivy
jag116542712jag
jagg136115312jagg
jig115633512jig
jiggy17549142jiggy
jigs126524762jigs
jog117438312jog
jug115529542jug
keg86432542keg
king95933662king
lag47862122lag
leg46446112leg
ling57447962ling
log46252682log
lug46138062lug
mag67956482mag
meg66040952meg
mig65646082mig
miggs96311372miggs
migs76935322migs
mog66949672mog
mug65837692mug
mugg86316012mugg
nag46450812nag
neg47237342neg
nigh85220662nigh
nog46847312nog
nogg65115942nogg
peg65843062peg
pig65744972pig
piggy124011432piggy
pigs76634222pigs
ping75943592ping
pug65337182pug
rag45761322rag
ragg65622692ragg
reg46146492reg
rig46748122rig
rigs55137592rigs
ring56541152ring
rug46039152rug
sag46163402sag
seg45544882seg
sigh85625892sigh
sign55523052sign
sing57544172sing
tag47259492tag
teg45741622teg
tegg65315922tegg
ting56139902ting
tog410255042tog
tug45937402tug
ugh76520682ugh
veg76931062veg
vig75637522vig
viga85622962viga
vigs85427272vigs
vug76127412vug
vugg95612712vugg
wag76451752wag
wig76740382wig
wiggy134510732wiggy
wigs84931252wigs
wing86339222wing
wog76242732wog
yag76947732yag
yegg96511792yegg
zag137539472zag
zig136931902zig
zigs145422792zigs
zing145728612zing

Search took 1 second 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.250714764.0
2DLD Change Limit140841490.34341061.2
3Display Results1491490.0304966.7
 (SQL Overall)1786911490.623286823.4
 
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.