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

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

35 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
assemblages165200(None) 
assemblage1552261assemblage_
assemblagist1761472assemblagist
assembles1354312assembl__es
assemblies1453062assembl_ies
reassemblages1861342reassemblages
assemblagists1871023assemblagists
assemble1254823assembl__e_
assembled1443693assembl__ed
assembler1343613assembl__er
assemblers1452883assembl_ers
assemblymen2061523assemblymen
assimilates1354413assimilates
reassemblage1761473reassemblage_
ambages1269624a___mb_ages
assembling1542884assembl_ing
assembly1543854assembl___y
assemblyman206884assemblyman
asseverates1452644asseverates
assimilate1254494assimilate_
assimilated1453764assimilated
assuages936274ass___uages
asswages1255054ass___wages
dissembles1545084dissembl__es
emblazes2135674___emblazes
ensembles1344014ensembl__es
fuselages1343544fuse__lages
reassembles1552784reassembl__es
reassemblies1661984reassembl_ies
resemblances1892214resemblances
resembles1376074resembl__es
semblables1642554__semblables
semblances1644214__semblances
stealages1046044_ste_alages
vassalages1452044vass__alages

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819359.11016335.8
3Display Results35350.0162187.5
 (SQL Overall)178691359.56218687.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.