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

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

36 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
disequilibrates27151681disequilibrates_
disequilibrate26121742disequilibrate__
disequilibrated28141552disequilibrate_d
disequilibria2571434disequilibr___ia
disequilibriums2981294disequilibriums_
equilibrates2352604___equilibrates_
disequilibrium2881435disequilibr__ium
equilibrate2252915___equilibrate__
equilibrated2462395___equilibrate_d
disaffiliates2062526disaffili__ates_
equilibrants2382266___equilibrants_
equilibrating2562206___equilibrating
equilibration2462366___equilibration
equilibrator2362146___equilibrat_or
equilibrators2461806___equilibrators
equilibratory2761676___equilibratory
debilitates1444477d__e_bili_tates_
deliberates1446797d__e___liberates_
disaffiliate1962637disaffili__ate__
disaffiliated2172437disaffili__ate_d
discriminates18174447dis_crimi_nates_
disqualifies2552497dis_quali__fies_
dissimilates15125197dis__simi_lates_
distillates1246157dis__til__lates_
disulfates14145367dis__u_l__fates_
equilibrant2282587___equilibra__nt
equilibrations2561977___equilibrations
equilibria2162377___equilibr___ia
equilibrist2262557___equilibr__ist
equilibrists2362287___equilibrists_
equilibriums2581887___equilibriums_
nonequilibria2471367nonequilibr___ia
nonequilibriums28191327nonequilibriums_
recalibrates1663467__re_calibrates_
semiliterates1552377__se_militerates_
sequestrates2152487__sequ_estrates_

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 Filter178691950240.356501941.0
2DLD Change Limit95024367.67312384.2
3Display Results36360.0301200.0
 (SQL Overall)178691368.05922172.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.