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

294 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
font7714375(None) 
fon66352271fon_
fond86330951fond
fons76943891fons
fonts86124751fonts
foot76248011foot
fort76456441fort
fount84727031fount
front85029221front
wont75842501wont
afoot8420112afoot
ant37270782_ant
aunt46553652aunt
bent67759912bent
bint67355042bint
biont7727162biont
boat66360312boat
bolt66254172bolt
bond75334362bond
bone65949322bone
bong75633412bong
bonk105531712bonk
bony96732082bony
boot67759372boot
bort65960962bort
bot59680402bo_t
bott66548572bott
bout66353292bout
bunt65850852bunt
cant66362022cant
cent67451012cent
coat67558342coat
coft97939682coft
colt67158242colt
con510268022con_
cone67256962cone
coni65534802coni
conk106531442conk
conn66229132conn
cons66057692cons
conte76633202conte
conto76027172conto
cony96537832cony
coot67860382coot
cost68057942cost
cot510483222co_t
count74932052count
cunt66243672cunt
dent57158412dent
dint56759052dint
doat56947672doat
doit56347852doit
dolt56649422dolt
don46757652don_
dona55529632dona
done55747912done
dong66031652dong
dons56048702dons
donut6324512donut
dost57248352dost
dot47573182do_t
dunt55746872dunt
eon36052082eon_
eons46638712eons
fact97142542fact
faint85837062faint
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fart76860562fart
fast77052312fast
fat68178082f_at
feat76458222feat
feet75352212feet
feint84732252feint
felt75146932felt
fen66851352fen_
fend84832972fend
fens76139762fens
fest74949442fest
fet66471632f_et
fiat76646642fiat
fin66458032fin_
find87532602find
fine75147952fine
fink117532122fink
fino76034692fino
fins75849092fins
fist76248422fist
fit66365452f_it
fixt1410729712fixt
flat77147822flat
flint87333502flint
flit76539272flit
float85928572float
flong95815682flong
flout86226202flout
foal76630922foal
foam97127172foam
fob86748332fo_b
fobs96034272fobs
foci94521012foci
foe66350812fo_e
foes76543442foes
fog76945562fo_g
fogs87035002fogs
fogy115923182fogy
foh98135892fo_h
fohn106116552fohn
fohns117310782fohns
foil76433912foil
foin77231562foin
foins85523382foins
foist85730972foist
fold86528942fold
folk116021542folk
foment113718302foment
fonds95824822fonds
fondu96013972fondu
fontal9313142fontal
food86830572food
fool75330592fool
foots85528282foots
footy115820532footy
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
forint9325022forint
fork115930942fork
form95836872form
forte86131462forte
forth116222672forth
forts86034452forts
forty114824272forty
foss76431642foss
fou66743782fo_u
foul77027582foul
found94917842found
founts94313382founts
four76226862four
fowl105723632fowl
fox136737862fo_x
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
frat75648542frat
fret75845042fret
frit77044472frit
frond95316342frond
frons86124042frons
fronts94415792fronts
frost84727832frost
fun66841142fun_
fund85624982fund
funk115825622funk
funs75235732funs
gent56954392gent
goat56250832goat
gone55639042gone
gong66827192gong
got49870442go_t
gout56646002gout
hant75461582hant
hent76656382hent
hint77455742hint
holt77852582holt
hon67759382hon_
hone77549322hone
hong85833952hong
honk116931192honk
hons77350782hons
hoot75752092hoot
host77852832host
hot67776052ho_t
hunt76445492hunt
ion36051022ion_
ions46737852ions
joint125227722joint
jolt116639122jolt
jot108259022jo_t
kent86846962kent
knot85630502knot
konk79320612konk
lent46360532lent
lint416266232lint
loft76539142loft
lone45849132lone
long56933342long
loot46955822loot
lost47951492lost
lot38179262lo_t
lout45952142lout
lunt46148842lunt
mint66758052mint
moat66352032moat
molt66356162molt
mon57561572mon_
monk105928512monk
mono66036712mono
mons68152252mons
monte75829772monte
month104818422month
mony96830002mony
moot67653622moot
mort66758832mort
most66554202most
mot57279422mo_t
mott66648442mott
mount74128062mount
nona46929062nona
none45743172none
nonet54540842nonet
not39474662no_t
nowt78833752nowt
oat39888262_oat
oft67744062_oft
on28057182_on_
one37050912_one
ono36838032_ono
ons36148512_ons
onto46127662_onto
oot311274692_oot
opt57545542_opt
ort39465232_ort
out38072152_out
pant66061252pant
pent66559072pent
pint66963172pint
poet65552902poet
point75338732point
pond75530492pond
pone65747532pone
pong76231142pong
pons65850602pons
pony96434052pony
port66059632port
post67953362post
pot58078432po_t
pout65752552pout
punt65747202punt
rant45864672rant
rent46661242rent
root45655922root
rot37282952ro_t
rout46153282rout
runt46647982runt
sent46963012sent
snot44745442snot
soft76942822soft
son37761952son_
sone46649982sone
song55133672song
sons46049552sons
soot45761052soot
sort46264812sort
sot310384292so_t
tent46159862tent
tint46758862tint
toft77441652toft
toit46353062toit
ton310265102ton_
tone46953742tone
tong56434352tong
tons46553052tons
tony75635152tony
toot45958882toot
tort46967462tort
tost48351922tost
tot38884772to_t
tout46753822tout
vent76049052vent
volt76439532volt
want76156162want
went76051872went
won66252062won_
wonk116125302wonk
wons74942042wons
wonts87621542wonts
wort76654752wort
wost76544362wost
wot610467482wo_t
yon67348952yon_
yond86122312yond
yoni77524392yoni
zona136321962zona
zone135231082zone
zonk175018622zonk

Search took 3 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 Filter178691298720.1401276364.3
2DLD Change Limit298722942.01614817.5
3Display Results2942940.1402100.0
 (SQL Overall)1786912942.29677827.1
 
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.