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

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

82 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
flamen11521599(None) 
flagmen13226911flagmen
flame105124441flame_
flamed124618971flamed
flamens124611061flamens
flamer114919121flamer
flames114723691flames
flaxen16518571flaxen
flymen14387771flymen
aflame1138722aflame_
amen66733152__amen
blame95625492blame_
blamed116017952blamed
blamer104417142blamer
blames105121862blames
examen1538282examen
fallen93813372fallen
fame95639392f_ame_
famed115928342f_amed
fames105735922f_ames
filament13410032filament
flacon1138632flacon
flagman13186172flagman
flagon1037982flagon
flake125119972flake_
flaked144715652flaked
flaker134916172flaker
flakes134118872flakes
flakey164410512flakey
flam96333292flam__
flambe13489152flambe
flambee144210012flambee
flambes14419502flambes
flamenco1543192flamenco
flamers124616362flamers
flamier123112142flamier
flaming134216442flaming
flammed15377412flammed
flams105125012flam_s
flamy135217472flam_y
flan76134182fla__n
flanes94522422flanes
flanken14226762flanken
flare84823632flare_
flared105317602flared
flares94521702flares
flatten10429652flatten
flavin1239302flavin
flawed134712722flawed
flaxes165015352flaxes
flayed134414052flayed
flayer124713562flayer
flehmen1534912flehmen
flume106021172flume_
flumed124915262flumed
flumes115119732flumes
flyman14326422flyman
foamed126014402foamed
foamer114714312foamer
foemen11310522foemen
foramen12310532foramen
frame105821802frame_
framed125116522framed
framer114817442framer
frames115119862frames
laden65022192_laden
lame66849292_lame_
lamed85235292_lamed
lament85024942_lament
lamer75233702_lamer
lames75445542_lames
laten54328342_laten
lawmen11308592_lawmen
laymen113010842_laymen
limen75426032_limen
lumen75220902_lumen
platen84518202platen
ramen75625192_ramen
seamen84518562seamen
stamen84115942stamen
velamen1237122velamen
yamen104115182_yamen

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 Filter178691825510.343520965.0
2DLD Change Limit82551822.09339441.5
3Display Results82820.0332484.8
 (SQL Overall)178691822.46972373.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.