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 “foehns” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

418 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
foehns1220497(None) 
foehn11236321foehn_
fohns117310781fo_hns
fehs106522382f_eh_s
fens76139762f_e_ns
ferns85220082f_erns
foes76543442foe__s
foetus958522foetus
fohn106116552fo_hn_
foins85523382fo_ins
fons76943892fo__ns
johns15398712jo_hns
aeons57624653_aeons
amens75624843ame_ns
avens86419333ave_ns
beans75734693_beans
bens65945703_be_ns
boches134618523boches
bogans95714813bogans
boheas114013213boheas
bohos105618253bo_hos
boons75031913bo_ons
boreens9310403boreens
borons85520543borons
boshes114721883boshes
bosons85016653bosons
bosuns8439383bosuns
bourns84114063bourns
brens75823363bre_ns
cleans85817053cleans
cochins141413103cochins
codeins103715483codeins
codens94821013codens
codons96119463codons
coeds85920163coe_ds
cogons96818113cogons
cohos105921853co_hos
coigns94410063coigns
coins75834553co_ins
colins85229043colins
colons86028683colons
conins84327233conins
conns75024233co_nns
cons66057693co__ns
coons76737283co_ons
copens106119963copens
corns76034763co_rns
coshes115022783coshes
cotans81317923cotans
covens114919263covens
covins114618063covins
cozens176314923cozens
deans66131393_deans
dens55945073_de_ns
doers65225713doe_rs
does56554473doe__s
dons56048703do__ns
dovens104413903dovens
downs94918573do_wns
doyens104810223doyens
dozens164612463dozens
ens37245923__e_ns
eons46638713__eons
eosins64419163eosins
erns45428233__erns
evens84817103eve_ns
fadeins1168503fadeins
faeces114713123faeces
faena85014203fae_na
faenas94412763faenas
fagins10513863fagins
fanons96115213fanons
fans76247373f__ans
fashes124524023fashes
fauns84516753f_auns
fawns115914263f_awns
fears84829393f_ears
feats86432753f_eats
feces105625363f_eces
fecks145417853f_ecks
feds85234313f_e_ds
feebs106112683f_eebs
feeds94921143f_eeds
feeing104416503feeing
feels85223043f_eels
fees76450603f_e_es
feezes184412613feezes
feh96136093f_eh__
feigns10407753feigns
feint84732253f_eint
feints94813873f_eints
fells85327383f_ells
felons93615763felons
felts85324543f_elts
femes105626223f_emes
fems96428703f_e_ms
fen66851353f_e_n_
fend84832973f_e_nd
fends96324973f_ends
fenny115115133f_enny
feods99516853f_eods
feoffs1163703feoffs
feres86038183f_eres
fern76129323f_ern_
ferny115816183f_erny
fes66551673f_e__s
fess76529163f_e_ss
fests85828043f_ests
fetas85624403f_etas
fetes85630143f_etes
fets75345943f_e_ts
fetus85816543f_etus
feuds95914883f_euds
feus75830753f_e_us
fezes175220023f_ezes
fiches145219533fiches
fichus14388113fichus
ficins113513983ficins
fiefs116213703fie_fs
fields104211043fields
fiend95312983fie_nd
fiends104110293fiends
fights133816553fights
fins75849093f__ins
firns86018543f_irns
fishes125221343fishes
fjelds17414473fjelds
flans85327973f_lans
fleams115011943fleams
fleas86423663fle_as
fleches153411443fleches
flecks154310803flecks
fleers96015793fleers
flees85828753fle_es
fleets96915063fleets
flehmens1643233flehmens
flense938903fle_nse
fleshes133913273fleshes
flews115316443fle_ws
flexes164512953flexes
fleys117015603fle_ys
floes85528143floe__s
florins10311643florins
foals85721693fo_als
foams105017953fo_ams
fobs96034273fo__bs
focus105815883fo_cus
foe66350813foe___
foeman11311233foeman
foemen11310523foemen
foetal9311883foetal
foetid10510513foetid
foetor939563foetor
foetors1039763foetors
fogeys13509263fogeys
foghorns1544113foghorns
fogies104118063fogies
fogs87035003fo__gs
foh98135893fo_h__
foils85025813fo_ils
foin77231563fo_in_
foisons1047613foisons
foists95413983foists
folds95221693fo_lds
foleys123810463foleys
folios93915463folios
folks126017123fo_lks
folles93820473folles
follis93113903follis
foment113718303foment
foments122912053foments
fon66352273fo__n_
fond86330953fo__nd
fonds95824823fo_nds
fondus105210943fondus
font77143753fo__nt
fonts86124753fo_nts
foods95924163fo_ods
fools86824203fo_ols
foots85528283fo_ots
fops96532683fo__ps
forams115115913forams
forays124813003forays
forbs105720803fo_rbs
forces114422133forces
fords95328183fo_rds
forehand1537693forehand
forehands1656743forehands
foreruns1146623foreruns
fores85847103fo_res
forests104114953forests
forges105024263forges
forint9325023forint
forints10411833forints
forks125324683fo_rks
formes114623713formes
forms105327053fo_rms
fortes95327183fortes
fortis95418613fortis
forts86034453fo_rts
forums114611843forums
foss76431643fo__ss
fossas94610703fossas
fosses96022083fosses
fouls87221433fo_uls
found94917843fo_und
founds104814193founds
fount84727033fo_unt
founts94313383founts
fours85521493fo_urs
foveas1238623foveas
fowls115518893fo_wls
foxes156321093fo_xes
foxhunt2043173foxhunt
foxhunts2141993foxhunts
foxing175012433foxing
foxings18446963foxings
foyers125413133foyers
foys105628293fo__ys
freaks134713063freaks
freers94717303freers
frees86131393fre_es
frena85915273fre_na
freres94716173freres
freshens14298313freshens
freshes133515823freshes
frets85523403fre_ts
froes86126693froe__s
frons86124043f_rons
froths125411443froth_s
frowns126011393frowns
fuels87117353fue_ls
funs75235733f__uns
furans94515953furans
futons93911513futons
gens55740073_ge_ns
gleans75014743gleans
glens66519853gle_ns
gobans94412043gobans
goers65520253goe_rs
goes55644093goe__s
goons65326773go_ons
gorhens1137183gorhens
goths96513003goth_s
governs1136103governs
gowans105512293gowans
gowns95115103go_wns
greens75716873greens
hehs106723963_heh_s
hens75642573_he_ns
herns84825583_herns
hoeing104117023hoeing
hoers85724923hoe_rs
hoes75755733hoe__s
hogans105914313hogans
honans94814503honans
hons77350783ho__ns
horns86125333ho_rns
iodins74216523iodins
ions46737853io__ns
jeans126022113_jeans
jehus15488573_jehus
joes116635893joe__s
joeys15518043joe_ys
john145512903jo_hn_
joins125818413jo_ins
joshes165114853joshes
keens95721183_keens
kens85435233_ke_ns
kerns94719563_kerns
koans95818623ko_ans
koels94613903koe_ls
kohls12437803ko_hls
kophs145010933koph_s
leans55536253_leans
lehrs86111133_lehrs
lens46146493_le_ns
liens56525503lie_ns
loans56026463lo_ans
lochans1248833lochans
lochs106715513loch_s
lodens74315063lodens
loess55714703loe_ss
logans76319063logans
logins77820643logins
logons79818173logons
loins56728423lo_ins
lomeins969483lomeins
loons55731723lo_ons
lorans65117603lorans
means75831233_means
miens76118303mie_ns
moans74624373mo_ans
mochas13310663mochas
moderns1037963moderns
mohels115011323mohels
mons68152263mo__ns
moons75331003mo_ons
moreens939963moreens
morns75527443mo_rns
morons84919543morons
moshes115222873moshes
moths106021553moth_s
mourns84111013mourns
neons55818683_neons
noels56418703noe_ls
noes45845393noe__s
noesis6311443noesis
noons54125283no_ons
noshes96618233noshes
nouns56717313no_uns
oceans81211003oceans
odeons739023odeons
oes35866193_oe__s
ohms95514033_o_hms
ohs66232313_o_h_s
okehs12477463okeh_s
oleins6313523oleins
omens75618963_omens
ons36148513_o__ns
oohs75220693_ooh_s
opens76118553_opens
ovens86217453_ovens
owns76819583_o_wns
paeans85118263paeans
paeons83915523paeons
peans75437643_peans
peens76428193_peens
pehs95625763_peh_s
peins76128063_peins
pens65649643_pe_ns
peons75327183_peons
pleons84213343pleons
poems95715553poe_ms
poets76024443poe_ts
poleyns1236113poleyns
pons65850603po__ns
poohs103915713pooh_s
poons75430973po_ons
porns75527343po_rns
poteens92910883poteens
pothos114214693pothos
preens85020113preens
qophs19507813qoph_s
queans153110753queans
queens15338873queens
querns15307943querns
reins56234563_reins
roans54926443ro_ans
robins83617453robins
roes45954143roe__s
romans84620243romans
roshis9311793roshis
rosins64521863rosins
rouens64814443rouens
rowans95715343rowans
rowens94515303rowens
sheens95116993sheens
skeans104512913skeans
skeens103912913skeens
skeins103911903skeins
solans64122493solans
solons65120023solons
somans84619303somans
sons46049553so__ns
sophs104916023soph_s
sorns55028423so_rns
soths86218633soth_s
sowans94215893sowans
sowens93613153sowens
sozins15510793sozins
speans85417143speans
steins64818343steins
sterns64616763sterns
teens56227483_teens
tens45647413_te_ns
terns55226873_terns
thegns10547433thegns
theins95015423theins
thens85921833the_ns
toeas55726423toe_as
toeing74418473toeing
toes46956443toe__s
tokens104711563tokens
tolans64319273tolans
tomans85419133tomans
tons46553053to__ns
toons55027533to_ons
tophes115218423tophes
tophs105220053toph_s
tophus115210363tophus
toshes94520103toshes
towns86018883to_wns
toxins133314283toxins
toyons95512133toyons
treens65317873treens
tweens9489843tweens
veins84620493_veins
voduns1035053voduns
voes75432823voe__s
weans85326743_weans
weens85224053_weens
wens76337933_we_ns
wheens124610613wheens
whens114618763whe_ns
woes76440663woe__s
womans114613653womans
wons74942043wo__ns
wovens12449833wovens
wrens85016243wre_ns
yeans86624883_yeans
yens75832263_ye_ns
yodhs12669013yodh_s
yoghs125410593yogh_s
yogins105114103yogins
zeins144715393_zeins
zoeas145815613zoe_as
zoons144919693zo_ons

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164185.25021469.7
3Display Results4184180.1263317.5
 (SQL Overall)1786914185.76630990.5
 
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.