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

344 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
fig7624284(None) 
big67345731big
cig67036191cig
dig57544481dig
fag76852361fag
fib86344281fib
fid76847701fid
fie67152451fie
figs85332651figs
fil65447151fil
fin66458041fin
fir66744901fir
fit66365461fit
fix136236111fix
fiz156238771fiz
fog76945561fog
frig85424501frig
fug76234511fug
gig56040761gig
jig115633521jig
mig65646091mig
pig65744981pig
rig46748131rig
vig75637531vig
wig76740391wig
zig136931911zig
ag311067462_ag
ai211288402ai_
aid49269092aid
ail37171052ail
aim57858222aim
ain37579102ain
air38058402air
ais39083582ais
ait38093912ait
bag67059222bag
beg65944132beg
bi48046482bi_
bib77045952bib
bid67751822bid
bigs76235032bigs
bin56658652bin
bio57846092bio
biog76122332biog
bis56860672bis
bit57070912bit
biz147939372biz
bog67852412bog
brig76528032brig
bug65340742bug
cigs75625112cigs
cis57748042cis
cog69552902cog
dag57753012dag
dib65746952dib
did56850532did
die46759662die
dif76846912dif
digs66036062digs
dim68146502dim
din46459472din
ding66940962ding
dip67848992dip
dis46459902dis
dit47071342dit
dog57449752dog
dug58138692dug
egg56918672egg
eng46726782eng
erg45531072erg
fa510148452f_a
fab87453132fab
fad77452422fad
fags86939122fags
fail74840242fail
fain75840562fain
fair76332522fair
fan67158862fan
fang85432562fang
far67762602far
fas68262932fas
fat68178082fat
fax138143312fax
fay97454862fay
fe57944742f_e
fed76548362fed
fee66862012fee
feh96136092feh
feign94210712feign
fem86040732fem
fen66851352fen
fer66646122fer
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fey95940882fey
fez156236822fez
fiar76427342fiar
fiat76646652fiat
fibs96329512fibs
fice95737122fice
fico95824602fico
fidge104516072fidge
fido87726412fido
fids87034752fids
fief107331372fief
fife106027712fife
fight124027092fight
fila74729142fila
file75446652file
fill75540202fill
film94828182film
filo76034292filo
fils75838702fils
find87532612find
fine75147962fine
fink117532132fink
fino76034702fino
fins75849102fins
fire76245602fire
firm96026462firm
firn76927512firn
firs76637722firs
fisc96819762fisc
fish106926282fish
fist76248432fist
fits76043472fits
five107629752five
fixt1410729722fixt
fizz157519832fizz
flag87427082flag
flic96223732flic
fling97023512fling
flip96324262flip
flir76422202flir
flit76539272flit
flog85523892flog
flu66530212flu
fly97124952fly
fob86748332fob
foe66350812foe
fogs87035002fogs
fogy115923182fogy
foh98135892foh
foil76433912foil
foin77231562foin
fon66352272fon
fop86743702fop
for66952072for
fou66743782fou
fox136737862fox
foy96044262foy
frag85126272frag
frigs96019272frigs
frit77044472frit
friz166324342friz
fro65530642fro
frog85624362frog
frug86517102frug
fry96226502fry
fub86337392fub
fud76335162fud
fugs85730692fugs
fugu85419862fugu
fun66841142fun
fur66637322fur
gag57753632gag
gib66443542gib
gid57047282gid
gie47149552gie
giga66720952giga
gigs66631192gigs
gin46055762gin
gip67645372gip
git46266062git
grig65424772grig
hag77255742hag
hi57947592hi_
hic86540572hic
hid76248392hid
hie67652712hie
high116619932high
him86247672him
hin67559572hin
hip86750442hip
his66359512his
hit66569202hit
hog78049062hog
hug76037362hug
id38941852_id
if57239962_if
iff96730402iff
ifs67124252ifs
igg57116802igg
in28150872_in
is27048222_is
it28455692_it
jag116542712jag
jib125835982jib
jigs126524772jigs
jin106443942jin
jog117438312jog
jug115529542jug
keg86432552keg
ki67537972ki_
kid86540632kid
kif105941202kif
kin76353982kin
king95933672king
kip97042152kip
kir76535692kir
kis78051492kis
kit78559892kit
lag47862122lag
leg46446112leg
li29948762li_
lib57750282lib
lid47453532lid
lie38264532lie
lin37967382lin
ling57447972ling
lip514755812lip
lis37162282lis
lit39377322lit
log46252682log
lug46138062lug
mag67956482mag
meg66040952meg
mi48249062mi_
mib76946132mib
mic77647652mic
mid67354482mid
migg85716812migg
migs76935332migs
mil55752122mil
mim76048432mim
mir57046782mir
mis58162632mis
mix126138192mix
mog66949672mog
mug65837692mug
nag46450812nag
neg47237342neg
nib56745202nib
nigh85220672nigh
nil36144202nil
nim57142962nim
nip56945992nip
nit37065952nit
nix106932842nix
nog46847312nog
oi29061492oi_
oil37452062oil
peg65843062peg
pi48145372pi_
pia56848042pia
pic76046832pic
pie55457412pie
pigs76634232pigs
pin57066732pin
ping75943602ping
pip78051052pip
pis56362042pis
pit56471932pit
piu56639552piu
pix126437942pix
prig75924872prig
pug65337182pug
qi116526912qi_
qis126934392qis
rag45761322rag
reg46146492reg
ria36745512ria
rib56848042rib
rid46754642rid
rif65951572rif
rigs55137602rigs
rim56052282rim
rin36663192rin
ring56541162ring
rip56851312rip
rug46039152rug
sag46163402sag
seg45544882seg
si29149582si_
sib56850322sib
sic55847882sic
sigh85625902sigh
sign55523062sign
sim56553152sim
sin36265902sin
sing57544182sing
sip57656022sip
sir35746682sir
sis37360552sis
sit35877762sit
six105339752six
swig85818022swig
tag47259502tag
teg45741622teg
ti28448302ti_
tic56343472tic
tie36557542tie
til36350272til
tin36362182tin
ting56139922ting
tip56551232tip
tis37056652tis
tit36771062tit
tog410255042tog
trig55528162trig
tug45937402tug
twig87615772twig
veg76931062veg
via65636252via
vid77241822vid
vie65447642vie
viga85622972viga
vigs85427282vigs
vim87437032vim
vis66747622vis
vug76127412vug
wag76451752wag
whig115516422whig
wigs84931262wigs
win66456302win
wing86339232wing
wis66552342wis
wit66563782wit
wiz156434162wiz
wog76242732wog
xi98128172xi_
xis106935342xis
yag76947732yag
yid76640842yid
yin67648742yin
yip87241192yip
zag137539472zag
zigs145422802zigs
zin125643782zin
zing145728622zing
zip146636232zip
zit126050002zit

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 Limit140843440.39335837.2
3Display Results3443440.0605733.3
 (SQL Overall)1786913440.703254183.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.