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

87 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
filament1341003(None) 
filaments1446651filaments
ailment9314232ail_ment
figment1379742fi_gment
firmament1645402firmament
fitment12710302fi_tment
flamen115215992f_lamen_
flamens124611062f_lamens
lament85024942__lament
ligament1149312ligament
ailments1039433ail_ments
aliment9316703_aliment
ament76036543___ament
armament1249633armament
bailment1249183bail_ment
bivalent1346123bivalent
calamint12315133calamint
clamant11312433_clamant
clement11313773_clement
defilement1648073defilement
dilatant948203dilatant
diligent1048033diligent
diluent8310263dil_uent
diriment11410743diriment
divalent1247783divalent
element9317803_element
ferment12315573f_erment
figments1446943fi_gments
filamentary1952353filamentary
filamentous1651403filamentous
filaree10611213filare_e
filarees1187643filarees
filbert12411643fil_bert
filemot1246703filem_ot
filet85540163fil__e_t
fillet95027083fil_le_t
filmed124610363fil_me_d
filmer114112403fil_me_r
filmers124211293fil_mers
filmiest1338553filmiest
filming133210353fil_ming
filmset1257513fil_mset
firemen1238773firemen_
firmaments1744293firmaments
firmest1239273fi_rmest
fitments1376793fi_tments
flagmen13226913f_lagmen_
flame105124443f_lame__
flamed124618973f_lame_d
flamenco1543193f_lamenco
flameout1347993f_lameout
flamer114919123f_lame_r
flamers124616363f_lamers
flames114723693f_lame_s
flamiest133111973f_lamiest
flaming134216443f_laming
flaunt9712913f_la_unt
flaxen16518573f_laxen_
fluent9313933f_l_uent
flymen14387773f_lymen_
foilsmen1354103foilsmen_
foment113718303f__oment
foramen12310533foramen_
foramens1337823foramens
fragment1448373fragment
fulgent1138903ful_gent
fundament1544953fundament
lambent113711303__lambent
laments94314853__laments
lamest84722763__lamest
latent64124303__latent
ligaments1246203ligaments
lineament1147843lineament
liniment1049533liniment
loment84021473__loment
milkmen1565213milkmen_
misagent11410723misagent
myofilament2161963myofilament
oilmen848313oil_men_
ointment1069233ointment
ornament1049133ornament
parament12415393parament
pigment12510733pi_gment
silent64125843sil__ent
velamen1237123velamen_
vilayet1348533vilaye_t
weldment1445823weldment

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.423422437.4
2DLD Change Limit146162877.34319904.9
3Display Results87870.0302900.0
 (SQL Overall)178691877.79622920.9
 
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.