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

366 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
flymen1438777(None) 
flamen115215991flamen
flyman14326421flyman
baymen134212002baymen
flagmen13226912flagmen
flame105124442flame_
flamed124618972flamed
flamens124611062flamens
flamer114919122flamer
flames114723692flames
flaxen16518572flaxen
flehmen1534912flehmen
flume106021172flume_
flumed124915262flumed
flumes115119732flumes
flyer114916252fly_er
flyte115713942flyte_
flyted13378772flyted
flytes123911562flytes
foemen11310522foemen
hymen13311042_hymen
laymen113010842laymen
limen75426032_limen
lumen75220902_lumen
skymen1535312skymen
acumen1049013acumen
admen84516183_admen
aflame1138723aflame_
aidmen92610373aidmen
airmen82612353airmen
albumen1135243albumen
alien56425583al_ien
aliment9316703aliment
alme65832163al_me_
almeh106214553al_meh
almes75126543al_mes
almsmen1144583almsmen
alumin8513543alumin
amen66733153__amen
ashmen1168173ashmen
axemen1547493axemen
axmen145112273_axmen
badmen114613833badmen
bagmen115412533bagmen
barmen105418533barmen
batmen104414303batmen
bayman133712703bayman
bellmen1138143bellmen
blame95625493blame_
blamed116017953blamed
blamer104417143blamer
blames105121863blames
blimey13468453blimey
blume95619893blume_
blumed114313643blumed
blumes105917793blumes
blype12429673blype_
blypes13357543blypes
bogymen1534763bogymen
bowmen1399853bowmen
busmen1039893busmen
cabmen123610653cabmen
carmen104019343carmen
cayman133613213cayman
chyme156512503chyme_
chymes165912153chymes
clement11313773clement
clime95720893clime_
climes104720003climes
cloven114211513cloven
clubmen1334253clubmen
clypei1334163clypei
cowmen13810923cowmen
cyme119420373_cyme_
cymene1377393_cymene
cymes1210118923_cymes
daimen92210573daimen
daysmen1335083daysmen
dolmen93911373dolmen
doyen95014413doy_en
draymen1335233draymen
element9317803element
eleven988303eleven
etymon1134693etymon
examen1538283examen
eyen76223663_ey_en
fallen93813373fallen
fame95639393f_ame_
famed115928343f_amed
fames105735923f_ames
farmed125117653farmed
farmer115017373farmer
fasten95114893fasten
fatten94314903fatten
fayed126422153fay_ed
feme96130543f_eme_
femes105626223f_emes
femme125011433femme_
femmes135410213femmes
fen66851353f___en
ferment12315573ferment
ferrymen1643943ferrymen
feyer115014523fey_er
figment1379743figment
filament13410033filament
filmed124610363filmed
filmer114112403filmer
firemen1238773firemen
firman112211343firman
firmed125411883firmed
firmer114712443firmer
fitment12710303fitment
flacon1138633flacon
flagman13186173flagman
flagon1037983flagon
flake125119973flake_
flaked144715653flaked
flaker134916173flaker
flakes134118873flakes
flakey164410513flakey
flam96333293flam__
flambe13489153flambe
flambee144210013flambee
flambes14419503flambes
flamenco1543193flamenco
flamers124616363flamers
flamier123112143flamier
flaming134216443flaming
flammed15377413flammed
flams105125013flam_s
flamy135217473flam_y
flan76134183fl__an
flanes94522423flanes
flanken14226763flanken
flare84823633flare_
flared105317603flared
flares94521703flares
flatten10429653flatten
flavin1239303flavin
flawed134712723flawed
flaxes165015353flaxes
flayed134414053flayed
flayer124713563flayer
flea75628493fl__ea
fled85429773fl__ed
flee76238793fl__ee
fleer86020773fl_eer
flees85828753fl_ees
fleet85932333fl_eet
flehmens1643233flehmens
flew105824253fl__ew
flex146123473fl__ex
flexed17419083flexed
flexes164512953flexes
fley106626853fl__ey
fleyed13408813fleyed
flied96519433fl_ied
flier86023403fl_ier
flies85630713fl_ies
flimsy14345563flimsy
flite85424963flite_
flited104616583flited
flites95122443flites
floe76129773fl_oe_
floes85528143fl_oes
flooey123910173flooey
floret9321123floret
florin9312653florin
flowed133513763flowed
flower124815503flower
flown116213993fl_own
flue75329853fl_ue_
flued95021253fl_ued
fluent9313933fl_uent
flues84626923fl_ues
fluke125016893fluke_
fluked145112093fluked
flukes135114193flukes
flukey16459813flukey
fluming133512793fluming
flump124614723flum_p
flumped15377713flumped
flumps135112503flumps
flute86823753flute_
fluted104917163fluted
fluter95316863fluter
flutes95421783flutes
flutey125212523flutey
fluxed17509673fluxed
fluxes165212933fluxes
fly97124953fly___
flybelt1594453flybelt
flyblew1841403flyblew
flyboy17113913flyboy
flyby1676003fly_by
flybys1792773flybys
flyers125712803flyers
flying134612153flying
flyleaf1642583flyleaf
flyless1335003flyless
flyoff1444023flyoff
flyover1633513flyover
flysch1732893flysch
flytier13356503flytier
flyting14378553flyting
flyway18134693flyway
foamed126014403foamed
foamer114714313foamer
foeman11311233foeman
foilsmen1354103foilsmen
foment113718303f_oment
footmen1246583footmen
foramen12310533foramen
foremen12412923foremen
forme105225993forme_
formed125021173formed
formee113919943formee
former114221403former
formes114623713formes
foyer116416553foy_er
frame105821803frame_
framed125116523framed
framer114817443framer
frames115119863frames
freemen1238463freemen
frogmen1335893frogmen
frozen18408443frozen
fryer115913433fry_er
frypan1434543frypan
fuglemen1443383fuglemen
fume96727633f_ume_
fumed116118823f_umed
fumer105918233f_umer
fumes105224703f_umes
fumet105630223f_umet
funnymen1642013funnymen
fyce126316833f_yce_
fyces139813643f_yces
fyke145915293f_yke_
fykes156312693f_ykes
gagmen103910413gagmen
gasmen93111563gasmen
germen9612313germen
gleemen1035723gleemen
glen56027203gl__en
glime85620193glime_
glimed105312283glimed
glimes94717523glimes
glume85120463glume_
glumes94516813glumes
gluten74210753gluten
glycan1234903glycan
glycin1235963glycin
gunmen9348723gunmen
hitmen11239193hitmen
hoyden13328933hoyden
hymens1437993_hymens
hymn12311313_hym_n
icemen1037893icemen
jurymen1943133jurymen
laden65022193_laden
lame66849293_lame_
lamed85235293_lamed
lament85024943_lament
lamer75233703_lamer
lames75445543_lames
laten54328343_laten
lawmen11308593lawmen
layman113511303layman
leben7314853_leben
legmen939343legmen
leman75622603_leman
lemon75618183_lemon
lien45339803_l_ien
liken911818843_liken
liman75921603_liman
lime66244933_lime_
limed85426803_limed
limens84618033_limens
limes75636503_limes
limey104721043_limey
limn66527693_lim_n
linen55728723_linen
liven85021733_liven
loden66621143_loden
lomein8410203_lomein
loment84021473_loment
lumens85013973_lumens
lumpen104010663_lumpen
lycea10418943_lycea
lycee104716743_lycee
lye66533413_ly_e_
lyes75530833_ly_es
lymph1547043_lymph
lyre75623793_lyre_
lyres85019963_lyres
lyse76320593_lyse_
lysed95011563_lysed
lyses84518253_lyses
lysin84512783_lysin
madmen113511743madmen
men59252843___men
mermen10813813mermen
milkmen1565213milkmen
nomen75621623_nomen
nonmen8412833nonmen
numen74216793_numen
oilmen848313oilmen
olden65114853ol_den
omen66828183__omen
oxygen1743313oxygen
payment14310703payment
penmen10311493penmen
pitmen102510793pitmen
platen84518203platen
playpen1434693playpen
plowmen1434883plowmen
plume94819463plume_
plumed114412883plumed
plumes104318133plumes
plumpen13276403plumpen
plyer106214333ply_er
polymer1438063polymer
potmen102713093potmen
premen105017803premen
ragmen93712183ragmen
ramen75625193_ramen
rhyme13479553rhyme_
rhymed15416713rhymed
rhymer14387083rhymer
rhymes14419823rhymes
riflemen1344243riflemen
rodmen939713rodmen
rumen74419503_rumen
seamen84518563seamen
semen75724103_semen
skyman1535313skyman
slime74925753slime_
slimed94915123slimed
slimes84722043slimes
sloven9389633sloven
slyer85515123sly_er
slype105112363slype_
slypes114410483slypes
socmen1039193socmen
stamen84115943stamen
syren85216743_syren
tallymen1343523tallymen
taxmen15367443taxmen
tegmen988403tegmen
telemen9310173telemen
thyme134612473thyme_
thymes144810743thymes
thymey17426313thymey
tinmen82310403tinmen
titmen8239883titmen
tollmen935733tollmen
vanmen1138403vanmen
velamen1237123velamen
vimen104114753_vimen
women104619253_women
yamen104115183_yamen
yen66847383__y_en
yeomen1138183yeomen
zyme1819114943_zyme_
zymes1924712943_zymes

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 Filter1786911127160.280638182.1
2DLD Change Limit1127163667.14315779.9
3Display Results3663660.1063452.8
 (SQL Overall)1786913667.52923733.7
 
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.