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

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

177 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
flame10512444(None) 
aflame1138721aflame
blame95625491blame
fame95639391f_ame
flake125119971flake
flam96333291flam_
flambe13489151flambe
flamed124618971flamed
flamen115215991flamen
flamer114919121flamer
flames114723691flames
flams105125011flams
flamy135217471flamy
flare84823631flare
flume106021171flume
frame105821801frame
lame66849291_lame
alae45643752ala_e
alamo7418142alamo
alane56135612alane
alate55340332alate
alme65832162al_me
arame75026622arame
blade85923332blade
blae66134642bla_e
blam86131702blam_
blamed116017952blamed
blamer104417142blamer
blames105121862blames
blams95023852blams
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
blume95619892blume
came87648752_came
clade85821012clade
clam86332292clam_
clamp115517652clamp
clams95127672clams
clave105420152clave
clime95720892clime
dame77140312_dame
elate55335882elate
enflame1236572enflame
face96140122f_ace
fade85736342f_ade
fake115534942f_ake
false84818122false
famed115928342f_amed
fames105735922f_ames
fane75343572f_ane
fare76354462f_are
fate75444282f_ate
fave105532962f_ave
faze165630042f_aze
fease84824872fease
feaze175216312feaze
feme96130542f_eme
femme125011432femme
flab96628352fla_b
flabs105818642flabs
flack144519412flack
flag87427082fla_g
flagmen13226912flagmen
flags95321282flags
flail85316182flail
flair86114122flair
flak116026172fla_k
flaked144715652flaked
flaker134916172flaker
flakes134118872flakes
flakey164410512flakey
flaky155715582flaky
flambee144210012flambee
flambes14419502flambes
flamens124611062flamens
flamers124616362flamers
flamier123112142flamier
flammed15377412flammed
flan76134182fla_n
flanes94522422flanes
flange103411972flange
flank124618092flank
flans85327972flans
flap96128702fla_p
flaps105621382flaps
flared105317602flared
flares94521702flares
flash115716212flash
flask125512422flask
flat77147822fla_t
flats86429742flats
flaw106326642fla_w
flawed134712722flawed
flaws115920342flaws
flawy145913382flawy
flax147325632fla_x
flaxen16518572flaxen
flaxes165015352flaxes
flaxy189012292flaxy
flay106332802fla_y
flayed134414052flayed
flayer124713562flayer
flays116321052flays
fleam106017282fleam_
fleams115011942fleams
flee76238792fl_ee
flite85424962flite
floe76129772fl_oe
flue75329852fl_ue
fluke125016892fluke
flumed124915262flumed
flumes115119732flumes
flump124614722flump
flute86823752flute
flymen14387772flymen
flyte115713942flyte
foam97127172foam_
foamed126014402foamed
foamer114714312foamer
foams105017952foams
foamy135313202foamy
folate93320392folate
forme105225992forme
frae75330472fra_e
framed125116522framed
framer114817442framer
frames115119862frames
fume96727632f_ume
game76644322_game
glace87420162glace
glade75121962glade
glam76529342glam_
glams85822932glams
glare65222962glare
glaze155418162glaze
glime85620192glime
glume85120462glume
hame97043132_hame
inflame1256962inflame
kame105728232_kame
lace66848472_lace
lade56345982_lade
lake85741602_lake
lam57666712_lam_
lama66635292_lama
lamb86832142_lamb
lamed85235292_lamed
lamer75233702_lamer
lames75445542_lames
lamp86233822_lamp
lams66552262_lams
lane45153332_lane
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
lime66244932_lime
llama799892llama
name65637412_name
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
plume94819462plume
same65245642_same
shame105726702shame
slake93724052slake
slam67737972slam_
slams74927902slams
slate55438282slate
slave84224032slave
slime74925752slime
tame66343662_tame
ulama7711472ulama
wame95035482_wame

Search took 3 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 Filter178691538000.346516448.0
2DLD Change Limit538001771.73331044.4
3Display Results1771770.0463847.8
 (SQL Overall)1786911772.12584089.9
 
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.