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

257 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
fonts8612475(None) 
fonds95824821fonds
fons76943891fon_s
font77143751font_
foots85528281foots
forts86034451forts
founts94313381founts
fronts94415791fronts
wonts87621541wonts
ants47243472_ants
aunts55227632aunts
bents76033692bents
bints76130182bints
bionts8612392bionts
boats75635152boats
bolts76232112bolts
bonds86126842bonds
bones76446532bones
bongs87828422bongs
bonks116326462bonks
bonus75324322bonus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
bunts75729802bunts
cants77036942cants
cents74730332cents
coats75634992coats
colts76633292colts
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692con_s
conte76633202conte
contes84432912contes
conto76027172conto
contos84923232contos
conus76726532conus
coots75636842coots
costs77231142costs
cots68054842co_ts
counts84618272counts
cunts76125122cunts
dents65031802dents
dints67431312dints
doats65224882doats
doits66223672doits
dolts65626312dolts
donas65926472donas
dongs76525812dongs
dons56048702don_s
donuts7410582donuts
dots55647662do_ts
dunts65828412dunts
eons46638712eon_s
facts107021892facts
faints94818782faints
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247362fan_s
farts88336842farts
fasts86429682fasts
fats76252502f_ats
feats86432752feats
feints94813872feints
felts85324542felts
fends96324972fends
fens76139762fen_s
fests85828042fests
fets75345942f_ets
fiats85324482fiats
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
fists85527542fists
fits76043462f_its
flats86429742flats
flints95617452flints
flits85625222flits
floats96816252floats
flongs105010492flongs
flouts94315272flouts
foals85721692foals
foams105017952foams
fobs96034272fo_bs
focus105815882focus
foes76543442fo_es
foetus958522foetus
fogs87035002fo_gs
fohns117310782fohns
foils85025812foils
foins85523382foins
foist85730972foist
foists95413982foists
folds95221692folds
folks126017122folks
foments122912052foments
fon66352272fon__
fond86330952fon_d
fondu96013972fondu
fondus105210942fondus
fontal9313142fontal
foods95924162foods
fools86824202fools
foot76248012foot_
footsy12587932footsy
footy115820532footy
fops96532682fo_ps
forbs105720802forbs
fords95328182fords
fores85847102fores
forints10411832forints
forks125324682forks
forms105327052forms
fort76456442fort_
forte86131462forte
fortes95327182fortes
forth116222672forth
fortis95418612fortis
forty114824272forty
foss76431642fo_ss
fouls87221432fouls
founds104814192founds
fount84727032fount_
fours85521492fours
fowls115518892fowls
foxes156321092foxes
foys105628292fo_ys
frats86829672frats
frets85523402frets
frits86129102frits
fronds106412342fronds
frons86124042fron_s
front85029222front_
frontes104214162frontes
frosts94214622frosts
funds94119252funds
funks125318912funks
funs75235732fun_s
gents65729612gents
goats65527302goats
gongs74921612gongs
gouts64826172gouts
hants86335402hants
hents87330742hents
hints87330622hints
holts85627912holts
hones88144492hones
hongs95126202hongs
honks125124522honks
hons77350782hon_s
hoots84830242hoots
hosts85526702hosts
hots78349322ho_ts
hunts86826172hunts
ions46737852ion_s
joints133811452joints
jolts125018882jolts
jones125028182jones
jots116336142jo_ts
knots95614722knots
konks84917112konks
lints57137192lints
lofts85518362lofts
longs65527062longs
loots55431422loots
lots47652092lo_ts
louts56330272louts
lunts55826902lunts
mints76834042mints
moats75827642moats
molts76032092molts
monas74732152monas
monks116123392monks
monos75930862monos
mons68152252mon_s
monte75829772monte
montes84226932montes
month104818422month
months113812932months
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
mounts84115072mounts
nonas55126652nonas
nones55639132nones
nonets64118702nonets
nowts86915852nowts
oats46554212_oats
ones46146532_ones
onos46229002_onos
ons36148512_on_s
onto46127662_onto
onus45826812_onus
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pants76536922pants
pints75936222pints
poets76024442poets
points85618532points
ponds85323402ponds
pones74547042pones
pongs85526342pongs
pons65850602pon_s
pontes83627852pontes
ports75934592ports
posts75228782posts
pots66452362po_ts
pouts75530322pouts
punts75828002punts
rants55935342rants
rents55935182rents
roots55933672roots
rots46454092ro_ts
routs57133412routs
runts55927632runts
snots55225102snots
softs85019232softs
sones55444142sones
songs67725552songs
sons46049552son_s
soots55536202soots
sorts54536662sorts
sots45552442so_ts
tents56434212tents
tints56030922tints
tofts84919242tofts
toits55327472toits
tones56048662tones
tongs65928462tongs
tons46553052ton_s
tonus56324302tonus
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
vents86125932vents
volts85421292volts
wants87932212wants
wonks124818342wonks
wons74942042won_s
wont75842502wont_
worts88631182worts
wots76342892wo_ts
yonis85020822yonis
zones145528042zones
zonks184815172zonks

Search took 4 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 Filter178691538000.1101624463.6
2DLD Change Limit538002572.51621383.1
3Display Results2572570.1701511.8
 (SQL Overall)1786912572.79663909.5
 
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.