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

241 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
flyman1432642(None) 
flymen14387771flymen
bayman133712702bayman
cayman133613212cayman
firman112211342firman
flagman13186172flagman
flamen115215992flamen
flan76134182fl__an
flyway18134692flyway
foeman11311232foeman
frypan1434542frypan
glycan1234902glycan
layman113511302layman
leman75622602_leman
liman75921602_liman
skyman1535312skyman
adman84517903_adman
aidman92410623aidman
airman82414223airman
alan46844083al__an
alma66333023al_ma_
almah106917253al_mah
almas76629773al_mas
almsman1145093almsman
alumin8513543alumin
alumna857343alumna
ashman1148383ashman
ataman81013063ataman
atman75520143_atman
axeman1538103axeman
axman144813183_axman
badman113813843badman
bagman114613813bagman
barman103519703barman
batman105214063batman
baymen134212003baymen
bellman1137183bellman
bogyman1544933bogyman
bowman13129853bowman
busman10310253busman
cabman123812503cabman
caiman103615663caiman
carman103920743carman
caymans14349513caymans
clamant11312433clamant
clan65633923cl__an
claypan1434313claypan
clean75420413cl_ean
climax1735653climax
clubman1344023clubman
cowman13910373cowman
cyan96419623_cy_an
cyma116715843_cyma_
cymae126713013_cymae
cymar125711263_cymar
cymas126417883_cymas
daman84821163_daman
daysman1335053daysman
desman9311693desman
dolman95312403dolman
drayman1335433drayman
elan46734243el__an
elysian1065083elysian
etyma1036583etyma_
etymon1134693etymon
fan67158853f___an
ferryman1643803ferryman
fireman1249333fireman
firmans12238523firmans
flab96628353fl__ab
flacon1138633flacon
flag87427083fl__ag
flagmen13226913flagmen
flagon1037983flagon
flak116026173fl__ak
flam96333293fl__am
flambe13489153flambe
flame105124443flam_e
flamed124618973flamed
flamens124611063flamens
flamer114919123flamer
flames114723693flames
flaming134216443flaming
flams105125013flam_s
flamy135217473flam_y
flank124618093fl__ank
flans85327973fl__ans
flap96128703fl__ap
flat77147823fl__at
flavin1239303flavin
flaw106326643fl__aw
flax147325633fl__ax
flaxen16518573flaxen
flay106332803fl__ay
flea75628493fl_ea_
fleam106017283fl_eam
fleams115011943fleams
fleas86423663fl_eas
flehmen1534913flehmen
flimsy14345563flimsy
float85928573fl_oat
flora85317103flora_
florae94713883florae
floral94313813floral
floras94715693floras
florin9312653florin
flota85315643flota_
flotas94013003flotas
flown116213993fl_own
flume106021173flum_e
flumed124915263flumed
flumes115119733flumes
fluming133512793fluming
flump124614723flum_p
flumps135112503flumps
fly97124953fly___
flyaway1943163flyaway
flyboat1546003flyboat
flyboy17113913flyboy
flyby1676003fly_by
flybys1792773flybys
flyer114916253fly_er
flyers125712803flyers
flying134612153flying
flyleaf1642583flyleaf
flyoff1444023flyoff
flypast1583753flypast
flysch1732893flysch
flyte115713943fly_te
flyted13378773flyted
flytes123911563flytes
flyting14378553flyting
flytrap1543253flytrap
flyways19133853flyways
foemen11310523foemen
foilsman1353773foilsman
footman1236403footman
foreman12312363foreman
formal113215203formal
formant123416003formant
format113021353format
freeman1237343freeman
frogman1335873frogman
frypans1544053frypans
fugleman1442673fugleman
fulmar1137253fulmar
funnyman1652123funnyman
furan84320013f_uran
gagman103811243gagman
gasman92911743gasman
german9611983german
glean65818203gl_ean
gleeman1035363gleeman
glucan936183glucan
glycans1344233glycans
glycin1235963glycin
gunman9299453gunman
hetman112510603hetman
hitman112710213hitman
human102716033_human
hymen13311043_hymen
hymn12311313_hym_n
iceman1037853iceman
juryman1943583juryman
lagan66520343_lagan
lama66635293_lama_
lamas75532793_lamas
lauan55216793_lauan
lawman11289053lawman
laymen113010843laymen
lean46345243_l_ean
legman949653legman
lemans85316393_lemans
lemon75618183_lemon
ligan67920283_ligan
lima65734133_lima_
limans84816303_limans
limas75627633_limas
limen75426033_limen
limn66527693_lim_n
llama799893llama_
llamas888973llamas
loan47436453_l_oan
logan68123283_logan
loran55925093_loran
luma65527523_luma_
lumas75622913_lumas
lumen75220903_lumen
lymph1547043_lymph
lysin84512783_lysin
madman113712383madman
man57465853___man
mayan105616903may_an
merman10513853merman
milkman1544913milkman
nonman8412363nonman
oilman839483oilman
outman83115033outman
penman10312323penman
pitman102412123pitman
plan65833943pl__an
platan83913693platan
plowman1444933plowman
potman102813573potman
preman104117453preman
pullman1135403pullman
pyran10514473_pyran
ragman94013713ragman
reman75730153_reman
rifleman1343413rifleman
rodman949713rodman
roman75424823_roman
seaman84015903seaman
shaman113314273shaman
skymen1535313skymen
slogan7539223slogan
socman1039813socman
soman75024903_soman
sylvan12257363sylvan
tallyman1344213tallyman
taxman15328613taxman
teleman959573teleman
tinman82411123tinman
titman82710993titman
tollman935863tollman
toman75724053_toman
tryma1037223tryma_
tympan13257013_tympan
ulama7711473ulama_
ulamas8910453ulamas
ulan46527393ul__an
ulema7109713ulema_
ulemas888963ulemas
ulpan7310123ul_pan
unman72715423_unman
vanman1139793vanman
woman105818003_woman
xylan1537463_xylan
yean75834583__yean
yeoman1138823yeoman
yuan76120013__yuan

Search took 7 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.1261418182.5
2DLD Change Limit1127162415.90619085.0
3Display Results2412410.0763171.1
 (SQL Overall)1786912416.10829255.2
 
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.