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 “disaggregating” 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
disaggregating176215(None) 
disaggregation1862692disaggregation
disaggregations1962512disaggregations
disaggregative2171592disaggregative
aggregating1343583___aggregating
desegregating1752733des_egregating
disaggregate1692433disaggregat__e
disaggregated1892243disaggregat_ed
disaggregates1782383disaggregat_es
reaggregating1552563_reaggregating
disagreeing1453864disa_gre__eing
resegregating1652844res_egregating
segregating1445454__s_egregating
aggravating1752415___aggravating
aggregation1454255___aggregation
aggregations1553845___aggregations
aggregative1753365___aggregative
congregating1754285__congregating
desegregation1663815des_egregation
desegregations1763565des_egregations
diagraming1544385di_a_gr__aming
disaffecting2252935disa_ffe_cting
disaffiliating2262275disaffiliating
disambiguating2171895disambiguating
disappearing1863145disa_ppe_aring
disarraying1644055disa__r_raying
disassociating1862475disassociating
discrediting1753215dis__crediting
disgorging1455015dis_gor_g__ing
disgracing1586745dis__gr__acing
disintegrating1763305dis_integrating
dispreading1645915dis__pre_ading
disrating11714555dis___r__ating
disregarding1652535dis___regarding
disseating121111785dis___se_ating
dissertating1474795dis_ser_tating
divagating1644005diva____gating
divaricating1953595diva__ricating
exaggerating2253185_exagg_erating
miscreating1648495mis__cre_ating
misrelating1447275mis___relating
mistreating1449285mis__tre_ating
reaggregation1653145_reaggregation
reaggregations1762845_reaggregations

Search took 6 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 Filter178691950240.356501941.0
2DLD Change Limit95024445.48617321.2
3Display Results44440.0301466.7
 (SQL Overall)178691445.87230431.0
 
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.