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

146 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
flatbeds1436454(None) 
flatbed13397981flatbed_
flambes14419502flambe_s
flatbreads1652242flatbreads
flatheads1644872flatheads
flatlets1147372flatlets
flatness1138152flatness
flatted114012942flatted_
flattens11357482flattens
flatters113814202flatters
alated75625143alat_ed_
alates64833963alat_e_s
blabbed11357813blabbed_
blabbers11308153blabbers
blathers134713793blathers
blatted104812713blatted_
blatters104414093blatters
clabbers14359903clabbers
clambers144211293clambers
clatters103313913clatters
daybeds14234473_daybeds
deathbeds1642183deathbeds
elated74725823elat_ed_
elaters74420193elat_ers
elates65032363elat_e_s
falters103916473falt_ers
fatbirds1443413f_atbirds
fated95632133f_at_ed_
fates85139233f_at_e_s
fatheads1536763f_atheads
fathers133916503f_athers
fatless103212203f_atless
fatness103311293f_atness
fatted105419843f_atted_
fattens105111713f_attens
feathers143513243feathers
flabs105818643fla_b__s
flacked173711583flacked_
flagged13459633flagged_
flaggers13328073flaggers
flagless1235403flagless
flailed1137303flailed_
flaked144715653fla_ked_
flakers143613273fla_kers
flakes134118873fla_ke_s
flambe13489153flambe__
flambeau1543323flambeau
flambeaus1642893flambeaus
flambee144210013flambe_e
flambeed16324383flambeed
flamed124618973fla_med_
flamens124611063fla_mens
flamers124616363fla_mers
flames114723693fla_me_s
flammed15377413flammed_
flanes94522423fla_ne_s
flanged123810843flanged_
flangers123311373flangers
flanges113413273flange_s
flanked153710643flanked_
flankers15349303flankers
flannels1134843flannels
flapless1335343flapless
flapped15328253flapped_
flappers15388383flappers
flared105317603fla_red_
flares94521703fla_re_s
flashed144112183flashed_
flashers143912653flashers
flashes133916103flashe_s
flaskets1534603flaskets
flatboat1346473flatboat
flatboats1444483flatboats
flatbread1542293flatbread
flatcaps1563403flatcaps
flatcars1344623flatcars
flatfeet1446213flatfeet
flathead1535803flathead
flatlands1364303flatlands
flatlet10312253flatle_t
flats86429743flat___s
flatten10429653flatte_n
flatter103815963flatte_r
flattery14338293flattery
flattest1138713flattest
flattops1344553flattops
flatus94310783flat__us
flatuses1137173flatuses
flatways1744323flatways
flawed134712723fla_wed_
flawless1434503flawless
flaxes165015353fla_xe_s
flaxseeds2041543flaxseeds
flayed134414053fla_yed_
flayers133912033fla_yers
flited104616583flit_ed_
flites95122443flit_e_s
flitted114011643flitted_
flitters114312173flitters
floated113312703float_ed_
floatels11295663float_els
floaters112711513float_ers
flubbed15306633flubbed_
flubbers15346893flubbers
fluted104917163flut_ed_
fluters103713683flut_ers
flutes95421783flut_e_s
flutters114010823flutters
flyted13378773flyt_ed_
flytes123911563flyt_e_s
flytiers14254483flytiers
folates103218453folat_e_s
fraters103517213frat_ers
hatreds11307813_hatreds
hotbeds13315003_hotbeds
labels84515683_la_bels
lakebeds1542583_lakebeds
lambed115614783_lambed_
lambers113817113_lambers
lameds94812033_la_meds
lated65240673_lat_ed_
lateens74210553_lateens
latens64620213_lat_ens
lathed104718453_lathed_
lathers104321883_lathers
lathes95127493_lathe_s
latkes104715873_latke_s
lattens75014673_lattens
lattes65324203_latte_s
malteds10377603malt_eds
plated95225773plat_ed_
platens94213983plat_ens
platers93924093plat_ers
plates85432243plat_e_s
platies93722543platie_s
platted103614263platted_
platters103415283platters
roadbeds1242763roadbeds
seabeds10417223sea_beds
slabbed12409503slabbed_
slabbers123610123slabbers
slated75028313slat_ed_
slaters73123733slat_ers
slates64934063slat_e_s
slathers113914783slathers
slatted84015183slatted_

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.403443402.0
2DLD Change Limit1461621467.28320068.9
3Display Results1461460.0463173.9
 (SQL Overall)1786911467.73223110.6
 
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.