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

339 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
gig5604075(None) 
big67345721big
cig67036181cig
dig57544471dig
fig76242831fig
gag57753631gag
gib66443531gib
gid57047261gid
gie47149541gie
giga66720941giga
gigs66631181gigs
gin46055751gin
gip67645361gip
git46266051git
grig65424771grig
igg57116791igg
jig115633511jig
mig65646081mig
pig65744971pig
rig46748121rig
vig75637521vig
wig76740381wig
zig136931901zig
ag311067462_ag
agin56132712agin
aging77026352aging
agio57828452agio
agog68019002agog
ai211288392ai_
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
bag67059222bag
beg65944132beg
bi48046472bi_
bib77045942bib
bid67751792bid
bigs76235022bigs
bin56658642bin
bio57846082bio
biog76122322biog
bis56860662bis
bit57070902bit
biz147939362biz
bog67852412bog
brig76528032brig
bug65340742bug
cigs75625102cigs
cis57748032cis
cog69552902cog
dag57753012dag
dib65746942dib
did56850512did
die46759652die
dif76846902dif
digs66036052digs
dim68146492dim
din46459462din
ding66940952ding
dip67848982dip
dis46459892dis
dit47071332dit
dog57449752dog
dug58138692dug
egg56918672egg
egis56520652egis
eng46726782eng
erg45531072erg
fag76852362fag
fib86344272fib
fid76847682fid
fie67152442fie
figs85332642figs
fil65447142fil
fin66458032fin
fir66744892fir
fit66365452fit
fix136236102fix
fiz156238762fiz
fog76945562fog
frig85424502frig
fug76234512fug
gab67155992gab
gad57556652gad
gae46457702gae
gaga66625552gaga
gage65936102gage
gags66441062gags
gain56042162gain
gait56150192gait
gal46055512gal
gam67060062gam
gan48060132gan
gang66031972gang
gap67055612gap
gar47259902gar
gas48870252gas
gat46880512gat
gay76856492gay
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
gey75738302gey
ghi77019882ghi
ghis85020162ghis
gibe75927782gibe
gibs75529272gibs
gids65933732gids
gied64631982gied
gien56330022gien
gies55641422gies
gift86735792gift
gigas75415582gigas
gighe10139732gighe
gigot74023072gigot
gigue71210672gigue
gild65526512gild
gill56336182gill
gilt56348542gilt
gimp96124042gimp
gink97129522gink
gins55543952gins
gips75632922gips
gird65424992gird
girl56226552girl
girn56026862girn
giro55828632giro
girt56646422girt
gist56046762gist
gite55438612gite
gits55744592gits
give85829352give
gleg66219802gleg
glia56423152glia
glib79421442glib
glim76026352glim
glug66118012glug
gnu45522042gnu
go38748742g_o
goa47343802goa
gob68950892gob
god57449792god
gogo69722832gogo
going75218492going
gong66827192gong
goo47754772goo
gor47848262gor
gos47155132gos
got49870442got
gox117137182gox
goy77844552goy
grid65829612grid
grigs75318192grigs
grim76929422grim
grin55733722grin
grip76127022grip
grit55247242grit
grog65923342grog
guid66022822guid
gul45832792gul
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
gym95719062gym
gyp98319012gyp
hag77255742hag
hi57947582hi_
hic86540562hic
hid76248372hid
hie67652702hie
high116619922high
him86247662him
hin67559562hin
hip86750432hip
his66359502his
hit66569192hit
hog78049062hog
hug76037362hug
id38941832_id
if57239952_if
iggs66612672iggs
in28150862_in
is27048212_is
it28455682_it
jag116542712jag
jib125835972jib
jigs126524762jigs
jin106443932jin
jog117438312jog
jug115529542jug
keg86432532keg
ki67537952ki_
kid86540612kid
kif105941182kif
kin76353962kin
king95933652king
kip97042132kip
kir76535672kir
kis78051472kis
kit78559872kit
lag47862122lag
leg46446112leg
li29948752li_
lib57750272lib
lid47453512lid
lie38264522lie
lin37967372lin
ling57447962ling
lip514755802lip
lis37162272lis
lit39377312lit
log46252682log
lug46138062lug
mag67956482mag
meg66040952meg
mi48249052mi_
mib76946122mib
mic77647642mic
mid67354462mid
migg85716802migg
migs76935322migs
mil55752112mil
mim76048422mim
mir57046772mir
mis58162622mis
mix126138182mix
mog66949672mog
mug65837692mug
nag46450812nag
neg47237342neg
nib56745192nib
nigh85220662nigh
nil36144192nil
nim57142952nim
nip56945982nip
nit37065942nit
nix106932832nix
nog46847312nog
oi29061482oi_
oil37452052oil
peg65843062peg
pi48145362pi_
pia56848032pia
pic76046822pic
pie55457402pie
pigs76634222pigs
pin57066722pin
ping75943592ping
pip78051042pip
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
prig75924872prig
pug65337182pug
qi116526902qi_
qis126934382qis
rag45761322rag
reg46146492reg
ria36745502ria
rib56848032rib
rid46754622rid
rif65951562rif
rigs55137592rigs
rim56052272rim
rin36663182rin
ring56541152ring
rip56851302rip
rug46039152rug
sag46163402sag
seg45544882seg
si29149572si_
sib56850312sib
sic55847872sic
sigh85625892sigh
sign55523052sign
sim56553142sim
sin36265892sin
sing57544172sing
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
swig85818022swig
tag47259492tag
teg45741622teg
ti28448292ti_
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
ting56139902ting
tip56551222tip
tis37056642tis
tit36771052tit
tog410255042tog
trig55528162trig
tug45937402tug
twig87615772twig
veg76931062veg
via65636242via
vid77241802vid
vie65447632vie
viga85622962viga
vigs85427272vigs
vim87437022vim
vis66747612vis
vug76127412vug
wag76451752wag
whig115516422whig
wigs84931252wigs
win66456292win
wing86339222wing
wis66552332wis
wit66563772wit
wiz156434152wiz
wog76242732wog
xi98128162xi_
xis106935332xis
yag76947732yag
yid76640822yid
yin67648732yin
yip87241182yip
zag137539472zag
zigs145422792zigs
zin125643772zin
zing145728612zing
zip146636222zip
zit126049992zit

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.0632836365.1
2DLD Change Limit140843390.37337758.7
3Display Results3393390.0635381.0
 (SQL Overall)1786913390.499358098.2
 
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.