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

285 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
foramen1231053(None) 
foramens1337821foramens
foremen12412921foremen
duramen1096902duramen
firemen1238772firemen
flamen115215992f_lamen
foamed126014402fo_amed
foamer114714312fo_amer
foemen11310522fo_emen
footmen1246582footmen
forage104617002forage_
foraged124812282foraged
forager114412562forager
forages114217282forages
foram105124932foram__
foramina1346162foramina
forams115115912foram_s
forayed14368592forayed
forayer13368952forayer
foreman12312362foreman
forme105225992for_me_
formed125021172for_med
formee113919942for_mee
former114221402for_mer
formes114623712for_mes
forsaken1543352forsaken
frame105821802f_rame_
framed125116522f_ramed
framer114817442f_ramer
frames115119862f_rames
frogmen1335892frogmen
ramen75625192__ramen
workmen1635932workmen
airmen82612353air_men
amen66733153___amen
arame75026623_arame_
arames84622573_arames
barmen105418533bar_men
birdmen1235833birdmen
boardmen1344073boardmen
boatmen1146913boatmen
bogymen1534763bogymen
bondmen1237893bondmen
bookmen15126263bookmen
boraces113716853boraces
borage93917013borage_
borages103917163borages
borane84620213borane_
boranes93720403boranes
borate85026153borate_
borated104116363borated
borates94823013borates
boraxes163511633boraxes
boreen8314313bor_een
bowmen1399853bo_wmen
brazen174812453_brazen
broaden10289143broaden
caramel11310253caramel
carmen104019343car_men
cerumen1147763cerumen
choremen1597603choremen
coarsen93210323coarsen
cormel103815603cor_mel
corpsmen1445633corpsmen
cowmen13810923co_wmen
craven114113933_craven
dolmen93911373do_lmen
doormen1036753doormen
dormer94415903dor_mer
dormin9312313dor_min
draymen1335233_draymen
duramens1195153duramens
examen1538283_examen
fame95639393f__ame_
famed115928343f__amed
fames105735923f__ames
farmed125117653far_med
farmer115017373far_mer
ferment12315573fer_ment
ferrymen1643943ferrymen
filament13410033filament
fireman1249333fireman
firmament1645403firmament
firman112211343fir_man
firmed125411883fir_med
firmer114712443fir_mer
flagmen13226913flagmen
flame105124443f_lame_
flamed124618973f_lamed
flamens124611063f_lamens
flamer114919123f_lamer
flames114723693f_lames
flaxen16518573f_laxen
flehmen1534913flehmen
florae94713883flora_e_
florigen12154633florigen
flymen14387773f_lymen
foaled104515963fo_aled
foam97127173fo_am__
foamers123812103fo_amers
foamier12339003fo_amier
foaming133612993fo_aming
foams105017953fo_am_s
foamy135313203fo_am_y
foeman11311233fo_eman
foilsmen1354103foilsmen
folacin1238053folacin
folate93320393folate_
folates103218453folates
foment113718303fo__ment
footman1236403footman
fora75937393fora___
foragers12349633foragers
foraging1358063foraging
foraminal1444263foraminal
foray115023973fora__y
forayers14277273forayers
foraying1537433foraying
forays124813003fora_ys
forbade13259103forbade_
forbare122310513forbare_
forbye14427883forbye_
force105324273for_ce_
forced126316523for_ced
forcer114917343for_cer
forces114422133for_ces
forded115020393for_ded
fordoes11311963fordoes
fordone1149383fordone
fore78351473for__e_
forearmed1544863forearmed
forefend1545603forefend
foreign1136833foreign
foreleg1137743foreleg
forename1347853forename_
forenamed1545163forenamed
forenames1447543forenames
foreran10311793foreran
forerun1037653forerun
fores85847103for__es
foresee10414333foresee
foreseen1139103foreseen
forever1338953forever
forewent1439423forewent
forewomen1746463forewomen
forfend1435413for_fend
forgave1435853forgave_
forge95126943for_ge_
forged115519323for_ged
forger104820773for_ger
forges105024263for_ges
forget106326393for_get
forgiven1542983forgiven
forgoer1137693forgoer
forgoes11311353forgoes
forgone1139343forgone
forked145217143for_ked
forker134717903for_ker
forkier144311593forkier
forlorn1096423forlorn
form95836873for_m__
formal113215203for_mal
formalin1347313formalin
formals123312893formals
formant123416003formant
format113021353for_mat
formate123115093formate
formates132814293formates
formats123113573formats
formers128217953for_mers
formic13310453for_mic
forming133615733for_ming
formol112910333for_mol
forms105327053for_m_s
formyl14276443for_myl
fornent10312933for_nent
forrader1236153forrader
forsake1436533forsake_
forsaker1545103forsaker
forsakes1536893forsakes
forspent1348163forspent
forte86131463for_te_
fortes95327183for_tes
forties104323863forties
fortune1068303fortune
forum108318763forum__
forums114611843forum_s
forwent13310533for_went
forworn13107793forworn
fourteen1144503fourteen
frae75330473f_ra_e_
fraena938063f_ra_ena
fragment1448373f_ragment
framers125113823f_ramers
framing133014793f_raming
frater94520593f_rater
frayed135012163f_rayed
freemen1238463freemen
frogman1335873frogman
frontmen1344423frontmen
frozen18408443f_rozen
furan84320013fura__n
furane94015493furane_
furanes103214863furanes
germen9612313ger_men
goodmen1135623goodmen
gorhen1038903gor_hen
gormed105013833gor_med
graben9419723_graben
graven104513523_graven
herdmen13238453herdmen
hoarsen10367993hoarsen
horsemen1347483horsemen
ironmen936453ironmen
joram145816983joram__
jorams154810533joram_s
jurymen1943133jurymen
kirkmen1232923kirkmen
kraken955883_kraken
loamed94414613lo_amed
loran55925093lora__n
lorimer937753lorimer
mermen10813813mer_men
morae75831193mora_e_
moraine9314573moraine
morale85220553morale_
morales93619403morales
moreen8313343mor_een
morgen9312203mor_gen
mortarmen1343213mortarmen
nomen75621623no__men
nonmen8412833no_nmen
normed95014543nor_med
oaken95814383_o_aken
oarsmen938093oarsmen
oaten55222403_o_aten
oilmen848313_oilmen
omen66828183_o__men
orate55133303_orate_
orated74221503_orated
orates64328613_orates
ormer75218373_or_mer
ornament1049133_ornament
parament12415393parament
postmen113110423postmen
potmen102713093po_tmen
premen105017803_premen
propmen1338763propmen
psoralen1063453psoralen
putamen1135923putamen
ragmen93712183__ragmen
ramee74633853__ramee
ramet75743143__ramet
raven84723443__raven
roamed95215093ro_amed
roamer84715163ro_amer
rodmen939713ro_dmen
rodsmen1035833rodsmen
rumen74419503__rumen
sagamen10127503sagamen
seamen84518563_seamen
sockmen1535453sockmen
socmen1039193so_cmen
sokemen1337053sokemen
sonarmen1045253sonarmen
stamen84115943_stamen
surfmen1235993surfmen
swordmen1443003swordmen
tollmen935733tollmen
tongmen1037123tongmen
torment9316173tor_ment
torten65314353tor_ten
tramel84113713_tramel
turfmen1244163turfmen
velamen1237123velamen
wiremen1236903wiremen
women104619253wo__men
woodmen1356053woodmen
woolmen1234973woolmen
workman1635613workman
wormed124314303wor_med
wormer114514913wor_mer
worsen95513873wor_sen
yamen104115183__yamen
yardmen1335423yardmen

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272856.86019537.5
3Display Results2852850.0933064.5
 (SQL Overall)1786912857.35924282.0
 
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.