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
fig7624283(None) 
big67345711big
cig67036181cig
dig57544471dig
fag76852361fag
fib86344261fib
fid76847681fid
fie67152441fie
figs85332641figs
fil65447141fil
fin66458031fin
fir66744891fir
fit66365451fit
fix136236101fix
fiz156238761fiz
fog76945561fog
frig85424501frig
fug76234511fug
gig56040751gig
jig115633511jig
mig65646071mig
pig65744971pig
rig46748121rig
vig75637521vig
wig76740381wig
zig136931901zig
ag311067462_ag
ai211288392ai_
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
bag67059222bag
beg65944132beg
bi48046462bi_
bib77045922bib
bid67751782bid
bigs76235012bigs
bin56658632bin
bio57846072bio
biog76122312biog
bis56860652bis
bit57070892bit
biz147939352biz
bog67852412bog
brig76528032brig
bug65340742bug
cigs75625102cigs
cis57748032cis
cog69552902cog
dag57753002dag
dib65746932dib
did56850512did
die46759652die
dif76846892dif
digs66036052digs
dim68146492dim
din46459462din
ding66940952ding
dip67848982dip
dis46459892dis
dit47071332dit
dog57449752dog
dug58138692dug
egg56918672egg
eng46726782eng
erg45531072erg
fa510148452f_a
fab87453132fab
fad77452412fad
fags86939122fags
fail74840242fail
fain75840562fain
fair76332522fair
fan67158852fan
fang85432542fang
far67762602far
fas68262932fas
fat68178082fat
fax138143312fax
fay97454862fay
fe57944742f_e
fed76548352fed
fee66862012fee
feh96136092feh
feign94210712feign
fem86040732fem
fen66851352fen
fer66646122fer
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fey95940882fey
fez156236822fez
fiar76427332fiar
fiat76646642fiat
fibs96329492fibs
fice95737112fice
fico95824582fico
fidge104516052fidge
fido87726392fido
fids87034732fids
fief107331352fief
fife106027702fife
fight124027092fight
fila74729132fila
file75446642file
fill75540192fill
film94828172film
filo76034282filo
fils75838692fils
find87532602find
fine75147952fine
fink117532122fink
fino76034682fino
fins75849092fins
fire76245592fire
firm96026452firm
firn76927502firn
firs76637712firs
fisc96819752fisc
fish106926272fish
fist76248422fist
fits76043462fits
five107629742five
fixt1410729712fixt
fizz157519822fizz
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
fud76335152fud
fugs85730692fugs
fugu85419862fugu
fun66841142fun
fur66637322fur
gag57753632gag
gib66443522gib
gid57047262gid
gie47149542gie
giga66720942giga
gigs66631182gigs
gin46055752gin
gip67645362gip
git46266052git
grig65424772grig
hag77255742hag
hi57947582hi_
hic86540562hic
hid76248362hid
hie67652702hie
high116619912high
him86247652him
hin67559562hin
hip86750432hip
his66359502his
hit66569192hit
hog78049062hog
hug76037362hug
id38941832_id
if57239942_if
iff96730382iff
ifs67124242ifs
igg57116792igg
in28150862_in
is27048212_is
it28455682_it
jag116542712jag
jib125835962jib
jigs126524762jigs
jin106443932jin
jog117438312jog
jug115529542jug
keg86432532keg
ki67537952ki_
kid86540612kid
kif105941172kif
kin76353962kin
king95933652king
kip97042132kip
kir76535672kir
kis78051472kis
kit78559872kit
lag47862122lag
leg46446112leg
li29948752li_
lib57750262lib
lid47453512lid
lie38264522lie
lin37967372lin
ling57447962ling
lip514755802lip
lis37162272lis
lit39377312lit
log46252682log
lug46138062lug
mag67956472mag
meg66040952meg
mi48249042mi_
mib76946102mib
mic77647632mic
mid67354452mid
migg85716792migg
migs76935312migs
mil55752102mil
mim76048412mim
mir57046762mir
mis58162612mis
mix126138172mix
mog66949672mog
mug65837692mug
nag46450812nag
neg47237342neg
nib56745182nib
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
rib56848022rib
rid46754622rid
rif65951552rif
rigs55137592rigs
rim56052272rim
rin36663182rin
ring56541152ring
rip56851302rip
rug46039152rug
sag46163402sag
seg45544882seg
si29149572si_
sib56850302sib
sic55847872sic
sigh85625892sigh
sign55523052sign
sim56553132sim
sin36265892sin
sing57544172sing
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
swig85818022swig
tag47259492tag
teg45741622teg
ti28448292ti_
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
ting56139892ting
tip56551222tip
tis37056642tis
tit36771042tit
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
yip87241172yip
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.0602978183.3
2DLD Change Limit140843440.36039122.2
3Display Results3443440.0635460.3
 (SQL Overall)1786913440.483369960.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.