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

51 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
unassembled165222(None) 
assembled1443692__assembled
reassembled1652572reassembled
assemble1254823__assemble_
assembler1343613__assembler
assembles1354313__assembles
disassembled1862193disassembled
dissembled1644413_dissembled
misassembled1961843misassembled
preassembled1951823preassembled
reassemble1453673reassemble_
reassembles1552783reassembles
unassailed1142913unass_ailed
assemblers1452884__assemblers
assemblies1453064__assemblies
assembly1543854__assembl_y
disassemble1652834disassemble_
disassembles1772294disassembles
dissemble1445804_dissemble_
dissembler1544314_dissembler
dissembles1545084_dissembles
ensemble1244974en__semble_
ensembles1344014en__sembles
misassemble1752384misassemble_
misassembles1861954misassembles
reassemblies1661984reassemblies
reassembly1752814reassembl_y
resembled1445174__resembled
subassemblies1981174subassemblies
subassembly2061314subassembl_y
tasseled935604_tasse__led
tasselled1044664_tasse_lled
unabsorbed1542364unabsorb_ed
unaneled939794una_ne__led
unashamed1543544unasham__ed
unassayed1343494unass__ayed
unassigned1262474unass_igned
unassimilated1662214unassimilated
unassisted1143834unass_isted
unassuaged1242404unass_uaged
unassured1084354unass__ured
unhumbled1743074un__humbled
unpassable1446134unpass_able_
unsampled1444444un__sampled
unscrambled1861714unscrambled
unsealed91513624un__se_aled
unseeable1149454un_seeable_
unsettled1055214un__settled
unshelled1336574un_she_lled
unsteeled1045764un_ste_eled
unstemmed1443304un_stem_med

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.423422437.4
2DLD Change Limit148819519.07616397.0
3Display Results51510.0331545.5
 (SQL Overall)178691519.53218746.4
 
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.