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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
flambeed1632438(None) 
flambee144210011flambee_
clambered16146132clambered
flambe13489152flamb_e_
flambeau1543322flambeau
flambes14419502flamb_es
flamed124618972flam__ed
flammed15377412flam_med
flatbed13397982flatb_ed
flaxseed1942572flaxseed
lambed115614782_lamb_ed
ambeer104511603__ambeer
ambled115116373__ambled
blabbed11357813bla_bbed
blabbered13184593blabbered
blamed116017953blam__ed
brambled15316733brambled
cambered15129003_cambered
chambered19145993chambered
clabbered16184763clabbered
clamber133311743clamb_er
clamberer15185273clamberer
clambers144211293clambers
clammed14369963clam_med
clamored1336953clamored
clamped144012043clam_ped
climbed14336983climb_ed
fabled124216383f_a_bled
famed115928343f_am__ed
filagreed1472873filagreed
flabbier1534093flabbier
flacked173711583fla_cked
flagged13459633fla_gged
flailed1137303fla_iled
flaked144715653fla__ked
flambeaus1642893flambeaus
flambeaux2351683flambeaux
flambeing1743933flambeing
flame105124443flam__e_
flamen115215993flam__en
flamens124611063flam_ens
flamer114919123flam__er
flamers124616363flam_ers
flames114723693flam__es
flamier123112143flam_ier
flamiest133111983flamiest
flamines13311643flamines
flanged123810843fla_nged
flanked153710643fla_nked
flanneled1343313flanneled
flapped15328253fla_pped
flared105317603fla__red
flashed144112183fla_shed
flatbeds14364543flatbeds
flatbread1542303flatbread
flatfeet1446213flatfeet
flathead1535813flathead
flatted114012943fla_tted
flattened13185303flattened
flattered13188633flattered
flaunted1234603flaunted
flavored1554583flavored
flawed134712723fla__wed
flaxseeds2041543flaxseeds
flayed134414053fla__yed
flubbed15306633fl_ubbed
flumed124915263flum__ed
flumped15377713flum_ped
foamed126014403foam__ed
framed125116523fram__ed
fumbled153710493f_umbled
gambled134112163_gambled
glaceed1136203gla_ceed
jambed184811403_jamb_ed
labeled102510563_la_beled
lakebed1434783_lakebed
lambent113711303_lambent
lamber104418493_lamb_er
lambers113817113_lambers
lambert113617113_lambert
lambie103213673_lambie_
lambier113611643_lambier
lambies113015113_lambies
lamed85235293_lam__ed
lammed113915623_lam_med
lamped114017543_lam_ped
limbed114513183_limb_ed
limbered13158123_limbered
lumbered13188233_lumbered
mamboed14417623_mamboed
plumbed14317273plumb_ed
rambled123913523_rambled
sambaed1238303_sambaed
shambled16156153shambled
slabbed12409503sla_bbed
slabbered14165083slabbered
slammed123511103slam_med
slumbered14215593slumbered
wambled153610753_wambled

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 Filter1786911461620.420425454.8
2DLD Change Limit146162997.25320151.9
3Display Results99990.0462152.2
 (SQL Overall)178691997.71923149.5
 
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.