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

59 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
filaments144665(None) 
filament13410031filament_
ailments1039442ail_ments
figments1446942fi_gments
filamentous1651402filamentous
firmaments1744292firmaments
fitments1376792fi_tments
flamens124611062f_lamen_s
laments94314852__laments
ligaments1246202ligaments
ailment9314233ail_ment_
aliments10311093_aliments
aments85219803___aments
armaments1347473armaments
bailments1346473bail_ments
bivalents1444123bivalents
calamints1348053calamints
defilements1747073defilements
dilatants1044513dilatants
diluents946063dil_uents
elements10312173_elements
ferments13311473f_erments
figment1379743fi_gment_
filamentary1952353filamentary
filarees1187643filare_es
filberts1334993fil_berts
filets94718953fil__e_ts
fillets103414753fil_le_ts
filmers124211293fil_me_rs
filmsets1353413fil_msets
firmament1645403firmament_
fitment12710303fi_tment_
flamen115215993f_lamen__
flamenco1543193f_lamenco
flamencos1642423f_lamencos
flameouts1443923f_lameouts
flamers124616363f_lame_rs
flames114723693f_lame__s
flamines13311643f_lamines
flaunts1056133f_la_unts
foments122912053f__oments
foramens1337823foramen_s
fragments1546213fragments
fundaments1653863fundaments
lament85024943__lament_
latents75214313__latents
ligament1149313ligament_
lineaments1245503lineaments
liniments1146613liniments
loments93413473__loments
misagents1246793misagents
myofilaments2261603myofilaments
ointments1166653ointments
ornaments1146633ornaments
paraments13511563paraments
pigments1337343pi_gments
silents73514493sil__ents
vilayets1443073vilaye_ts
weldments1544423weldments

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 Filter1786911486410.423422437.4
2DLD Change Limit148641597.06021054.0
3Display Results59590.0163687.5
 (SQL Overall)178691597.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.