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

101 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
fohns11731078(None) 
foehns12204971foehns
fohn106116551fohn_
foins85523381foins
fons76943891fo_ns
johns15398711johns
bohos105618252bohos
boons75031912boons
cohos105921852cohos
coins75834552coins
conns75024232conns
cons66057692co_ns
coons76737282coons
corns76034762corns
dons56048702do_ns
downs94918572downs
eons46638712eo_ns
fans76247372f_ans
fauns84516752fauns
fawns115914262fawns
fehs106522382feh_s
fens76139762f_ens
ferns85220082ferns
fins75849102f_ins
firns86018542firns
flans85327972flans
foals85721692foals
foams105017952foams
fobs96034272fo_bs
focus105815882focus
foehn11236322foehn_
foes76543442fo_es
fogs87035002fo_gs
foh98135892foh__
foils85025812foils
foin77231562foin_
folds95221692folds
folks126017122folks
fon66352272fo_n_
fond86330952fo_nd
fonds95824822fonds
font77143752fo_nt
fonts86124752fonts
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682fo_ps
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
foss76431642fo_ss
fouls87221432fouls
found94917842found
founds104814192founds
fount84727032fount
founts94313382founts
fours85521492fours
fowls115518892fowls
foxes156321092foxes
foys105628292fo_ys
frons86124042frons
frowns126011392frowns
funs75235732f_uns
goons65326772goons
gowns95115102gowns
hons77350782ho_ns
horns86125332horns
ions46737852io_ns
john145512902john_
joins125818412joins
koans95818622koans
kohls12437802kohls
loans56026462loans
loins56728422loins
loons55731722loons
moans74624372moans
mons68152262mo_ns
moons75331002moons
morns75527442morns
noons54125282noons
nouns56717312nouns
ohms95514032_ohms
ohs66232312_oh_s
ons36148512_o_ns
oohs75220692ooh_s
owns76819582_owns
phons105221142phons
pons65850602po_ns
poons75430972poons
porns75527342porns
roans54926442roans
sons46049552so_ns
sorns55028422sorns
tons46553052to_ns
toons55027532toons
towns86018882towns
wons74942042wo_ns
zoons144919692zoons

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 Filter178691538000.313570897.8
2DLD Change Limit538001011.50035866.7
3Display Results1011010.0137769.2
 (SQL Overall)1786911011.82697859.3
 
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.