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

189 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
flare8482363(None) 
blare75826231blare
fare76354461f_are
flake125119971flake
flame105124441flame
flared105317601flared
flares94521701flares
glare65222951glare
aflame1138722aflame
aglare7312422aglare
alae45643752ala_e
alane56135612alane
alar46340072alar_
alarm76621422alarm
alary86123442alary
alate55340322alate
are37874572__are
aware86420022aware
bare65460522_bare
blade85923332blade
blae66134642bla_e
blame95625492blame
blared95018242blared
blares85021632blares
blase75524232blase
blate75933782blate
blaze165520832blaze
care66968372_care
chare105231982chare
clade85821012clade
claret84026572claret
claro75018692claro
clary105719612clary
clave105420152clave
dare55848862_dare
elate55335882elate
face96140122f_ace
fade85736342f_ade
fake115534942f_ake
false84818122false
fame95639392f_ame
fane75343572f_ane
far67762602f_ar_
farce104925322f_arce
fard85639062f_ard
fared95842342f_ared
farer86733142f_arer
fares85852872f_ares
farl76338552f_arl
farle86929242f_arle
farm95934532f_arm
faro76136922f_aro
fart76860562f_art
fate75444282f_ate
fave105532962f_ave
faze165630042f_aze
fear75337792fear_
feared106320432feared
fearer94820182fearer
fears84829392fears
fease84824872fease
feaze175216312feaze
fere76342232f_ere
fiacre1137622fiacre
fiar76427332fiar_
fiars86720832fiars
fibre104812842fibre
filar84819292filar_
filaree10611212filaree
fire76245592f_ire
flab96628352fla_b
flabs105818642flabs
flack144519412flack
flag87427082fla_g
flags95321282flags
flail85316182flail
flair86114122flair
flairs95711912flairs
flak116026172fla_k
flaked144715652flaked
flaker134916172flaker
flakes134118872flakes
flakey164410512flakey
flaky155715582flaky
flam96333292fla_m
flambe13489152flambe
flamed124618972flamed
flamen115215992flamen
flamer114919122flamer
flames114723692flames
flams105125012flams
flamy135217472flamy
flan76134182fla_n
flanes94522422flanes
flange103411972flange
flank124618092flank
flans85327972flans
flap96128702fla_p
flaps105621382flaps
flareup1243172flareup
flash115716212flash
flask125512422flask
flat77147822fla_t
flats86429742flats
flaw106326642fla_w
flawed134712722flawed
flaws115920342flaws
flawy145913382flawy
flax147325632fla_x
flaxen16518572flaxen
flaxes165015352flaxes
flaxy189012292flaxy
flay106332802fla_y
flayed134414052flayed
flayer124713562flayer
flays116321052flays
flee76238792fl_ee
fleer86020772fleer
flier86023402flier
flir76422202flir_
flirs85518932flirs
flirt87424752flirt
flite85424962flite
floe76129772fl_oe
flora85317102flora
florae94713882florae
floret9321122floret
flue75329852fl_ue
fluke125016892fluke
flume106021172flume
flute86823752flute
flyer114916252flyer
flyte115713942flyte
folate93320392folate
fore78351472f_ore
frae75330472fra_e
frame105821802frame
frere85617722frere
frore86218802frore
glace87420152glace
glade75121962glade
glaire74411292glaire
glared84715192glared
glares75518862glares
glary96018542glary
glaze155418162glaze
hare76255732_hare
lace66848472_lace
lade56345982_lade
lake85741602_lake
lame66849292_lame
lane45153332_lane
lar37967532_lar_
lard56742002_lard
laree56036292_laree
lares54852632_lares
large65325462_large
lari45839152_lari
lark85733862_lark
lars46956572_lars
lase46148512_lase
late47560482_late
lave75642142_lave
laze136235052_laze
lire47845292_lire
lore45850352_lore
lure45142462_lure
lyre75623792_lyre
mare64759332_mare
pare66760842_pare
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
quare143920542quare
rare45348432_rare
scare75334462scare
share86437082share
slake93724052slake
slate55438282slate
slave84224032slave
snare54429982snare
spare75135562spare
stare54440262stare
sware85828212sware
tare45957622_tare
urare56322552urare
ware76254722_ware
yare75636942_yare

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.313570897.8
2DLD Change Limit538001891.78030224.7
3Display Results1891890.0633000.0
 (SQL Overall)1786911892.15682880.8
 
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.