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

378 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
aflame113872(None) 
flame105124441_flame
ablate82219212ablate
ablaze17239832ablaze
aglare7312432aglare
alae45643752a_la_e
alamo7418142a_lamo
alane56135612a_lane
alate55340332a_late
alme65832162a_l_me
anlace82513922anlace
anlage72514232anlage
arame75026622a_rame
blame95625492_blame
enflame1236572enflame
fame95639392_f_ame
flake125119972_flake
flam96333292_flam_
flambe13489152_flambe
flamed124618972_flamed
flamen115215992_flamen
flamer114919122_flamer
flames114723692_flames
flams105125012_flams
flamy135217472_flamy
flare84823632_flare
flume106021172_flume
frame105821802_frame
inflame1256962inflame
lame66849292__lame
abamp11310603a_bamp
abase76023483a_base
abate76627843a_bate
abeam9316533abeam_
ablated102513443ablated
ablates92416903ablates
ablaut8313263ablaut
able66340533abl__e
abrade9313053abrade
acme86924323a__cme
acuate8315633acuate
acylate12310533acylate
adage7414053a_dage
adnate72913483adnate
adulate8313233adulate
aerate64830553aerate
afar76720783af_a_r
afars85716513af_ars
afeard1058263afeard
afeared1176833afeared
affable15117403affable
affair1234353affair
affaire1344463affaire
affine12310503affine
afire86215913af_ire
afloat9315153afloat
afore85818603af_ore
afraid1049723afraid
agama85815583a_gama
agape85614843a_gape
agate66525153a_gate
agave95314033a_gave
agaze156113663a_gaze
agleam9158623agleam_
aglee65728493agl_ee
agnate73314883agnate
agrafe1038093agrafe
airframe1344293airframe
ala312463603a_la__
alack114820063a_lack
alameda1035493a_lameda
alamode1038163a_lamode
alamos8415003a_lamos
alan46844083a_la_n
aland65526413a_land
alang66023513a_lang
alans55636173a_lans
alant55742293a_lant
alar46340073a_la_r
alarm76621423a_larm
alarmed1037743a_larmed
alarms85913053a_larms
alary86123443a_lary
alas46358123a_la_s
alated75625153a_lated
alates64833973a_lates
alcade91111513alcade
ale36572343a_l__e
alee46652323a_l_ee
alfa77624273alfa__
alfaki1385383alfaki
alfas87219043alfa_s
algae65319623a_lgae
alike95523963a_like
aline57243153a_line
alive85722513a_live
alkane104313323alkane
alkie95520033a_lkie
allay85620393alla_y
allayed11138063allayed
allayer10148213allayer
allays94313743allays
allee54932123a_llee
allege74314653allege
allele64514563allele
allude73910903allude
allure63012943allure
alma66333023a_l_ma
almah106917253a_lmah
almas76629773a_lmas
almeh106214553a_l_meh
almes75126543a_l_mes
alms65834923a_l_ms
aloe45540193a_l_oe
alone55732963a_lone
alulae6312743alula_e
alum65227613a_lum_
alums75720603a_lums
amaze166016603a_maze
ambage11510603ambage
amylase1237023amylase
anime75423203a_nime
anlaces92313733anlaces
anlagen8238643anlagen
anlages82414113anlages
anlas55626933anla_s
anlases72514903anlases
ansae55720973ansa_e
ansate64517863ansate
antae56828293anta_e
apace94718383a_pace
aplite8316393aplite
aplomb1236203aplomb
aquae142212713aqua_e
arames84622573a_rames
arcade91013643arcade
arcane81216743arcane
areae55229743area_e
ashamed1336243ashamed
aslant6317753aslant
aslope839013aslope
asrama839193asrama
assume897563assume
atlas55821583atla_s
atlases72410643atlases
atlatl637873atlatl
aubade939223aubade
aurae54128113aura_e
aurate64426473aurate
aviate9315203aviate
awake125014783a_wake
aware86420023a_ware
axle116424603axl__e
axlike17388853axlike
ballade104012563ballade
ballgame1343653ballgame
became123213163became
beldame1237233beldame
bename103316073bename
blade85923333_blade
blae66134643_bla_e
blam86131703_blam_
blamed116017953_blamed
blamer104417143_blamer
blames105121863_blames
blams95023853_blams
blare75826233_blare
blase75524233_blase
blate75933783_blate
blaze165520833_blaze
blume95619893_blume
byname13256363byname
calami10313423calami
came87648753__came
clade85821013_clade
clam86332293_clam_
clamp115517653_clamp
clams95127673_clams
clave105420153_clave
clime95720893_clime
dame77140313__dame
defame123212433defame
deflate113613943deflate
degame102713183degame
delate73827753delate
delime9314043delime
dilate73220693dilate
efface14366673efface
elate55335883_elate
enflamed1455723enflamed
enflames1357043enflames
enframe1247363enframe
enlace82213233enlace
facade1238803facade
face96140123_f_ace
fade85736343_f_ade
fake115534943_f_ake
falafel1383903falafel
falcate12311623falcate
false84818123fal_se
falsie93513853falsie
famed115928343_f_amed
fames105735923_f_ames
fane75343573_f_ane
fare76354463_f_are
fate75444283_f_ate
fave105532963_f_ave
faze165630043_f_aze
fease84824873_fease
feaze175216313_feaze
feme96130543_f_eme
femme125011433_femme
flab96628353_fla_b
flabs105818643_flabs
flack144519413_flack
flag87427083_fla_g
flagmen13226913_flagmen
flags95321283_flags
flail85316183_flail
flair86114123_flair
flak116026173_fla_k
flaked144715653_flaked
flaker134916173_flaker
flakes134118873_flakes
flakey164410513_flakey
flaky155715583_flaky
flambee144210013_flambee
flambes14419503_flambes
flamens124611063_flamens
flamers124616363_flamers
flamier123112143_flamier
flammed15377413_flammed
flan76134183_fla_n
flanes94522423_flanes
flange103411973_flange
flank124618093_flank
flans85327973_flans
flap96128703_fla_p
flaps105621383_flaps
flared105317603_flared
flares94521703_flares
flash115716213_flash
flask125512423_flask
flat77147823_fla_t
flats86429743_flats
flaw106326643_fla_w
flawed134712723_flawed
flaws115920343_flaws
flawy145913383_flawy
flax147325633_fla_x
flaxen16518573_flaxen
flaxes165015353_flaxes
flaxy189012293_flaxy
flay106332803_fla_y
flayed134414053_flayed
flayer124713563_flayer
flays116321053_flays
fleam106017283_fleam_
fleams115011943_fleams
flee76238793_fl_ee
flite85424963_flite
floe76129773_fl_oe
flue75329853_fl_ue
fluke125016893_fluke
flumed124915263_flumed
flumes115119733_flumes
flump124614723_flump
flute86823753_flute
flymen14387773_flymen
flyte115713943_flyte
foam97127173_foam_
foamed126014403_foamed
foamer114714313_foamer
foams105017953_foams
foamy135313203_foamy
folate93320393folate
forme105225993_forme
frae75330473_fra_e
framed125116523_framed
framer114817443_framer
frames115119863_frames
fume96727633_f_ume
gallate83417133gallate
game76644323__game
gelate73421263gelate
glace87420163_glace
glade75121963_glade
glam76529343_glam_
glams85822933_glams
glare65222963_glare
glaze155418163_glaze
glime85620193_glime
glume85120463_glume
hame97043133__hame
haulage1136913haulage
haylage1436443haylage
illume8298223illume
inflamed1446033inflamed
inflamer1356123inflamer
inflames1377323inflames
inflate10312313inflate
inlace82513043inlace
kalam11315113kalam_
kalams12310603kalams
kame105728233__kame
lace66848473__lace
lade56345983__lade
lake85741603__lake
lam57666713__lam_
lama66635293__lama
lamb86832143__lamb
lamed85235293__lamed
lamer75233703__lamer
lames75445543__lames
lamp86233823__lamp
lams66552263__lams
lane45153333__lane
lase46148513__lase
late47560483__late
lave75642143__lave
laze136235053__laze
lime66244933__lime
llama799893_llama
macrame1338713macrame
madame1139853madame
malate84624563malate
melamed1249633melamed
milage93414123milage
name65637413__name
oblate82214743oblate
palace104516923palace
palate84226793palate
pelage9515363pelage
place94824613_place
plage84520403_plage
plane74929143_plane
plate74635113_plate
plume94819463_plume
preflame1545913preflame
reclame11411063reclame
reflate103516263reflate
reframe1239393reframe
relace83122153relace
relate64033633relate
relume8313273relume
rename82718813rename
salami8313103salami
same65245643__same
sesame8311013sesame
shame105726703_shame
silage72715303silage
silane62718053silane
slake93724053_slake
slam67737973_slam_
slams74927903_slams
slate55438283_slate
slave84224033_slave
slime74925753_slime
solace83415823solace
solate64526073solate
splake1259783splake
tallage82712073tallage
tame66343663__tame
telae54323293tela_e
telome8311923telome
tolane64316583tolane
ulama7711473_ulama
ullage739043ullage
unlace82215173unlace
unlade72714153unlade
untame82513603untame
vallate103016563vallate
velamen1237123velamen
velate93720143velate
volume11358273volume
waftage14115323waftage
wakame1535433wakame
wame95035483__wame

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.390458182.1
2DLD Change Limit1127163786.93616250.9
3Display Results3783780.2831335.7
 (SQL Overall)1786913787.60923484.2
 
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.