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

429 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
flambes1441950(None) 
flambe13489151flambe_
flambee144210011flambee
flames114723691flam_es
blames105121862blam_es
clamber133311742clamber
clambers144211292clambers
crambes1339962crambes
fames105735922f_am_es
flabs105818642fla_b_s
flakes134118872fla_kes
flambeau1543322flambeau
flambeaus1642892flambeaus
flambeed16324382flambeed
flame105124442flam_e_
flamed124618972flam_ed
flamen115215992flam_en
flamens124611062flamens
flamer114919122flam_er
flamers124616362flamers
flamier123112142flamier
flamiest133111972flamiest
flamines13311642flamines
flammed15377412flammed
flams105125012flam__s
flanes94522422fla_nes
flanges113413272flanges
flares94521702fla_res
flashes133916102flashes
flatbed13397982flatbed
flatbeds14364542flatbeds
flaxes165015352fla_xes
flumes115119732flum_es
frames115119862fram_es
gambes116318312_gambes
jambes175914052_jambes
lambed115614782_lambed
lamber104418492_lamber
lambers113817112_lambers
lambies113015112_lambies
lambs95921412_lamb_s
lames75445542_lam_es
abbes96723523__abbes
aflame1138723aflam_e_
alamodes1148013alamodes
alamos8415003alam_os
alates64833963ala_tes
almes75126543al_m_es
amber94523213__amber
ambers104519583__ambers
ambles105121863__ambles
ambos95321253__ambos
amies76837693__amies
arames84622573aram_es
babes95834113_ba_bes
barbes104526233_barbes
blabbed11357813blabbed
blabber10418923blabber
blabbers11308153blabbers
blabs95619633bla_b_s
blades95221253bla_des
blame95625493blam_e_
blamed116017953blam_ed
blamer104417143blam_er
blamers115314213blamers
blams95023853blam__s
blares85021633bla_res
blazes174817353bla_zes
blumes105917793blum_es
bombes124916823_bombes
brambles14308973brambles
camber124418483_camber
cambers134017443_cambers
cames97047313_cam_es
chamber164011063chamber
chambers173410623chambers
clabber134210113clabber
clabbers14359903clabbers
clades94920463cla_des
clambakes1943313clambakes
clammed14369963clammed
clammer134211793clammer
clammers143510693clammers
clamors11710093clamors
clamped144012043clamped
clamper134012993clamper
clampers143211893clampers
clamps124515083clam_ps
clams95127673clam__s
claques18279013claques
claries93422203claries
claroes93113733claroes
clashes124017283clashes
classes94717943classes
clauses93813323clauses
claves115020063cla_ves
climbed14336983climbed
climber13449133climber
climbers14318413climbers
climbs12498723climb_s
climes104720003clim_es
clumber134011443clumber
clumbers143910413clumbers
combes125321733_combes
coombes133810663coombes
crambe1239073crambe_
cramboes1436543cramboes
crambos1336783crambos
dames85435853_dam_es
daubes94913703_daubes
elapses957663elapses
elates65032363ela_tes
enflames1357043enflam_es
fabber134814113f_abber
fabbest1438033f_abbest
fables114921673f_ables
fabs98635863f_a_b_s
faces106439433f_a_ces
facies113921593f_acies
fades94932863f_a_des
fadges114814033f_adges
faeces114713123f_aeces
fakes126032483f_a_kes
falces115216003f_alces
falsies103515013falsies
fame95639393f_am_e_
famed115928343f_am_ed
famines123216263f_amines
famous11412393f_amous
fanes84639893f_a_nes
farces115223323f_arces
fares85852873f_a_res
farles96025783f_arles
fasces114914543f_asces
fashes124524023f_ashes
fates85139233f_a_tes
fauces114916153f_auces
fauves125610423f_auves
faves115331423f_a_ves
faxes155726653f_a_xes
fazes175527213f_a_zes
feases95422923fea_ses
feazes184514173fea_zes
females12310663females
femes105626223f_em_es
femmes135410213f_emmes
fiacres1237253fiacres
fiances12310673fiances
filarees1187643filarees
fimbles143510663f_imbles
flab96628353fla_b__
flabbier1534093flabbier
flabbiest1644203flabbiest
flabby1634573fla_bby
flacked173711583flacked
flacks154114533fla_cks
flacons1238053flacons
flagged13459633flagged
flagger12469353flagger
flaggers13328073flaggers
flagless1235403flagless
flagmen13226913flagmen
flagons1137973flagons
flags95321283fla__gs
flailed1137303flailed
flails94313003fla_ils
flairs95711913fla_irs
flake125119973fla_ke_
flaked144715653fla_ked
flaker134916173fla_ker
flakers143613273flakers
flakey164410513fla_key
flakier143910203flakier
flakiest153210543flakiest
flam96333293flam___
flambeaux2351683flambeaux
flambeing1743933flambeing
flameless1435353flameless
flaming134216443flaming
flammables1942233flammables
flamy135217473flam__y
flange103411973flange_
flanged123810843flanged
flanger113412623flanger
flangers123311373flangers
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flankers15349303flankers
flanks133913403fla_nks
flannel1035423flannel
flannels1134843flannels
flans85327973fla__ns
flapless1335343flapless
flapped15328253flapped
flapper14359203flapper
flappers15388383flappers
flaps105621383fla__ps
flare84823633fla_re_
flared105317603fla_red
flashed144112183flashed
flasher133914063flasher
flashers143912653flashers
flasket1439733flasket
flaskets1534603flaskets
flasks13488673fla_sks
flatlet10312253flatlet
flatlets1147373flatlets
flatmates1446193flatmates
flatness1138153flatness
flats86429743fla__ts
flatted114012943flatted
flatten10429653flatten
flattens11357483flattens
flatter103815963flatter
flatters113814203flatters
flattest1138713flattest
flatus94310783fla_tus
flatuses1137173flatuses
flaunts1056133flaunts
flautas1036153flautas
flavines1437893flavines
flavins1338543flavins
flavones1435833flavones
flavors1337293flavors
flawed134712723fla_wed
flawier13378733flawier
flawiest14298573flawiest
flawless1434503flawless
flaws115920343fla__ws
flaxen16518573fla_xen
flaxier17337983flaxier
flaxiest18298183flaxiest
flayed134414053fla_yed
flayer124713563fla_yer
flayers133912033flayers
flays116321053fla__ys
fleams115011943fleam__s
fleches153411443fleches
fledges12409393fledges
fleeces12399643fleeces
flees85828753fl__ees
flenses1039473flenses
fleshes133913273fleshes
flexes164512953fl_exes
flies85630713fl__ies
flimsies1335783flimsies
flites95122443fl_ites
floes85528143fl__oes
flosses103411973flosses
flubbed15306633flubbed
flubber14287713flubber
flubbers15346893flubbers
flubs105515443fl_ub_s
flues84626923fl__ues
flukes135114193fl_ukes
flume106021173flum_e_
flumed124915263flum_ed
flumped15377713flumped
flumps135112503flum_ps
flushes134114143flushes
flutes95421783fl_utes
fluxes165212933fl_uxes
flybys1792773fl_ybys
flymen14387773flym_en
flytes123911563fl_ytes
foamed126014403foam_ed
foamer114714313foam_er
foamers123812103foamers
foamier12339003foamier
foamiest13289853foamiest
foamless13195843foamless
foams105017953foam__s
folates103218453fola_tes
formes114623713form_es
fraises104215693fraises
frambesia16142033frambesia
frame105821803fram_e_
framed125116523fram_ed
framer114817443fram_er
framers125113823framers
frappes14328383frappes
frasses104314513frasses
fumbles143514413f_umbles
fumes105224703f_um_es
gambas115817513_gambas
gambe106219213_gambe_
gambles124016203_gambles
gambs105721123_gamb_s
games86238553_gam_es
glaces94218023gla_ces
glades84820343gla_des
glaires84010133glaires
glaives11347833glaives
glamors1068113glamors
glams85822933glam__s
glances104113143glances
glandes95413833glandes
glares75518863gla_res
glasses84414273glasses
glazes165315643gla_zes
glebes95512243gl_ebes
glimes94717523glim_es
globes94314543gl_obes
glumes94516813glum_es
grammes123611323grammes
hames106138703_ham_es
iambs95815063_iamb_s
iambus10468903_iambus
inflames1377323inflam_es
jambe165314753_jambe_
jambed184811403_jambed
jambs166014623_jamb_s
kames115024693_kam_es
label75019383_la_bel
labels84515683_la_bels
labs67145123_la_b_s
laces76141763_la_ces
laches116528343_laches
lades65141273_la_des
ladies75124883_ladies
ladles74619543_ladles
lakes95737653_la_kes
lamas75532793_lam_as
lamb86832143_lamb__
lambast11129893_lambast
lambda1146113_lambda
lambdas1246243_lambdas
lambent113711303_lambent
lambert113617113_lambert
lamberts12348793_lamberts
lambie103213673_lambie
lambier113611643_lambier
lambiest122410183_lambiest
lamby125114843_lamb_y
lame66849293_lam_e_
lamed85235293_lam_ed
lameds94812033_lameds
lamer75233703_lam_er
lamest84722763_lam_est
lamias85020613_lamias
lammed113915623_lammed
lampas106615953_lampas
lamped114017543_lamped
lampers113817333_lampers
lamps95624833_lam_ps
lams66552263_lam__s
lances84824103_lances
lanes54946793_la_nes
lapses85217693_lapses
larees65323113_larees
lares54852633_la_res
larges74824233_larges
lases54944763_la_ses
lashes94831003_lashes
lasses64827593_lasses
lathes95127493_lathes
latkes104715873_latkes
lattes65324203_lattes
laves86039153_la_ves
laxes125430093_la_xes
lazes145129573_la_zes
lazies154418783_lazies
limbas105313203_limbas
limbed114513183_limbed
limber104316793_limber
limbers113614743_limbers
limbos104712143_limbos
limbs96118943_limb_s
limbus105710383_limbus
limes75636503_lim_es
llamas888973llam_as
lobes75331003_l_obes
lubes74727993_l_ubes
lumber103817773_lumber
lumbers113815913_lumbers
mabes96331533_ma_bes
mambas125716243_mambas
mamboes135011823_mamboes
mambos125414493_mambos
mamies104626243_mamies
maybes1339243_maybes
nabes75427093_na_bes
names74833363_nam_es
places104323703pla_ces
plages94520153pla_ges
plagues103311063plagues
plaices11411143plaices
planes85028083pla_nes
plaques18317893plaques
plashes124417393plashes
plates85432243pla_tes
platies93722543platies
plebes104313623pl_ebes
plumbed14317273plumbed
plumber13339983plumber
plumbers14418513plumbers
plumbs12459333plumb_s
plumes104318133plum_es
rambles113118313_rambles
ramees84620893_ramees
ramies84630463_ramies
sabes76437463_sa_bes
sambas104219263_sambas
sambos104315193_sambos
shambles15159043shambles
shames114726223sham_es
shammes144312833shammes
slabbed12409503slabbed
slabber113311393slabber
slabbers123610123slabbers
slabs75322643sla_b_s
slakes104021883sla_kes
slammed123511103slammed
slammer113913033slammer
slammers123511223slammers
slams74927903slam__s
slashes103619103slashes
slates64934063sla_tes
slaves95023023sla_ves
slimes84722043slim_es
slumber113811003slumber
slumbers123110273slumbers
swamies123712063swamies
tabes76033923_ta_bes
tames75242013_tam_es
ulamas8910453ulam_as
wambles143714023_wambles
wames106432803_wam_es

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 Filter1786911340270.830215290.4
2DLD Change Limit1340274296.70319995.1
3Display Results4294290.1562750.0
 (SQL Overall)1786914297.68923239.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.