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

124 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
fohn10611655(None) 
foehn11236321foehn
foh98135891foh_
fohns117310781fohns
foin77231561foin
fon66352271fo_n
john145512901john
boho96923322boho
boon67142172boon
born67338412born
chon96627792chon
coho97524492coho
coin66645352coin
con510268022co_n
conn66229132conn
coon67248942coon
corn69945812corn
don46757652do_n
down86427492down
eon36052082eo_n
fain75840562fain
fan67158862f_an
faun76226622faun
fawn105321952fawn
feh96136092feh_
fehs106522382fehs
fen66851352f_en
fern76129322fern
fin66458032f_in
firn76927502firn
flan76134182flan
flown116213992flown
foal76630922foal
foam97127172foam
fob86748332fo_b
fobs96034272fobs
foci94521012foci
foe66350812fo_e
foehns12204972foehns
foes76543442foes
fog76945562fo_g
fogs87035002fogs
fogy115923182fogy
foil76433912foil
foins85523382foins
fold86528942fold
folk116021542folk
fond86330952fond
fons76943892fons
font77143752font
food86830572food
fool75330592fool
foot76248012foot
fop86743702fo_p
fops96532682fops
for66952072fo_r
fora75937392fora
forb97131332forb
ford86835492ford
fore78351472fore
fork115930942fork
form95836872form
fort76456442fort
foss76431642foss
fou66743782fo_u
foul77027582foul
found94917842found
fount84727032fount
four76226862four
fowl105723632fowl
fox136737862fo_x
foxy176517752foxy
foy96044262fo_y
foys105628292foys
fozy197017162fozy
frown115415972frown
fun66841142f_un
goon57236172goon
gown85724072gown
hon67759382ho_n
horn76735612horn
ion36051022io_n
johns15398712johns
join116724832join
koan85425032koan
kohl113911712kohl
loan47436452loan
loin46838722loin
loon47344792loon
lorn46435252lorn
lown76929292lown
moan65832022moan
mon57561582mo_n
moon67140812moon
morn66237562morn
mown95424442mown
noh66640642noh_
noon47134622noon
noun45724182noun
oh57447002_oh_
ohm86523012_ohm
oho66534382_oho
ohs66232312_ohs
on28057182_o_n
ooh67637092ooh_
oohs75220692oohs
own66429702_own
phon95925382phon
poh86740532poh_
poon67341262poon
porn65636022porn
roan47234202roan
son37761952so_n
soon46240502soon
sorn46641062sorn
sown75127452sown
ton310265102to_n
toon47740632toon
torn46044252torn
town76928702town
won66252062wo_n
worn75631752worn
yon67348952yo_n
zoon137326982zoon

Search took 2 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.266671770.7
2DLD Change Limit298721240.92332364.0
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.219146588.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.