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

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

44 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
reassemblages186134(None) 
reassemblage1761471reassemblage_
assemblages1652002__assemblages
reassembles1552782reassembl__es
reassemblies1661982reassembl_ies
assemblage1552263__assemblage_
reassemble1453673reassembl__e_
reassembled1652573reassembl__ed
assemblagist1761474__assemblagist
assembles1354314__assembl__es
assemblies1453064__assembl_ies
preassembled1951824preassembl__ed
reassembling1752104reassembl_ing
reassembly1752814reassembl___y
resemblances1892214re__semblances
resembles1376074re__sembl__es
assemblagists1871025__assemblagists
assemble1254825__assembl__e_
assembled1443695__assembl__ed
assembler1343615__assembl__er
assemblers1452885__assembl_ers
assemblymen2061525__assemblymen
assimilates1354415__assimilates
disassembles1772295disassembl__es
disassemblies1881905disassembl_ies
dissembles1545085_dissembl__es
ensembles1344015_e_nsembl__es
misassembles1861955misassembl__es
reassesses945065reasse___sses
reassumes1144465reassum____es
reembraces1643895re___embraces
repassages1343055repass____ages
resemblance17112335re__semblance
resemblant1453105re__sembla_nt
resemble1247315re__sembl__e_
resembled1445175re__sembl__ed
resembler1344585re__sembl__er
resemblers1443415re__sembl_ers
restimulates1465315re_stimulates
subassemblies1981175subassembl_ies
tesselates1043935te_sse__lates
tessellates1162475te_sse_llates
unassembled1652225unassembl__ed
vassalages1452045_vass__alages

Search took 9 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 Filter1786911247900.393454684.5
2DLD Change Limit124790448.14015330.5
3Display Results44440.0133384.6
 (SQL Overall)178691448.54620909.3
 
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.