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

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
dissolutions1314492(None) 
dissolution12145021dissolution_
absolutions1344713_absolutions
desolations12310593d_esolations
devolutions15106263d_evolutions
dilutions10248583di___lutions
disillusions1352323disillusions
dislocations15136983dislocations
dispositions1546473dispositions
disrelations1348503disrelations
dissections14198263diss_ections
dissentions12168043diss_entions
dissipations1546533dissipations
dissociations1656013dissociations
distortions1246613disto_rtions
exsolutions1844013_exsolutions
insolations1149183_insolations
involutions1445903_involutions
isolations10310693_i_solations
nonsolutions1254173nonsolutions
resolutions11117793_resolutions
solutions988883___solutions
absolution1244404_absolution_
coevolutions1754084coevolutions
consolations1449744consolations
convolutions1745194convolutions
demolitions1446524d_emolitions
desolation11311404d_esolation_
desorptions1445994d_esorptions
despoliations1646394despoliations
destitutions1385254destitutions
devolution1486284d_evolution_
dilations102614454di___lations
dilution9239144di___lution_
diluvions13224444di___luvions
diminutions1444544di_minutions
discolorations17104304discolorations
disconsolations1863204disconsolations
discretions1447224di_scretions
disfunctions1854524disfunctions
disillusion1252394disillusion_
disinflations1756294disinflations
disjunctions2254074disjunctions
dislocation14147504dislocation_
displosions14203834di_splosions
disposition1446684disposition_
disputations15106174disputations
disrelation1248814disrelation_
disruptions14125684di_sruptions
dissection13158614diss_ection_
dissensions12175574diss_ensions
dissention11188074diss_ention_
dissentious12184474diss_entious
dissertations1465894dissertations
dissimilations1755864dissimilations
dissimulations1754904dissimulations
dissipation1447214dissipation_
dissociation1556644dissociation_
dissolute1045754dissolut___e
dissolutely1562334dissolut_ely
dissoluteness1462704dissoluteness
dissolving1545114dissol_vi_ng
dissuasions1243524diss_uasions
distentions12178844di_stentions
distillations1446944distillations
distinctions1557324distinctions
distortion1146694disto_rtion_
distractions1548754distractions
distributions1665124distributions
disunions1055974di_s__unions
evolutions13107044__evolutions
exsolution1743764_exsolution_
immolations1545474_immolations
insolation10410214_insolation_
insulations11310234_insulations
involution1345944_involution_
irresolutions13162374irresolutions
isolation9311644_i_solation_
mislocations16145654mislocations
mispositions1655304mispositions
nonsolution1154744nonsolution_
resolution1097734_resolution_
revolutions1497634_revolutions
solations9814624___solations
solution889594___solution_
violations1337964vi__olations
volutions12108394___volutions

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 Filter1786911247900.390458182.1
2DLD Change Limit124790877.20317324.7
3Display Results87870.0461891.3
 (SQL Overall)178691877.63923391.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.