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

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

33 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
disequilibrates2715168(None) 
disequilibrate26121741disequilibrate_
disequilibrated28141551disequilibrated
disequilibriums2981293disequilibriums
equilibrates2352603___equilibrates
disequilibria2571434disequilibr__ia
disequilibrium2881434disequilibr_ium
equilibrate2252914___equilibrate_
equilibrated2462394___equilibrated
disaffiliates2062525disaffili__ates
equilibrants2382265___equilibrants
equilibrator2362145___equilibrator
equilibrators2461805___equilibrators
debilitates1444476d__e_bili_tates
deliberates1446796d__e___liberates
disaffiliate1962636disaffili__ate_
disaffiliated2172436disaffili__ated
discriminates18174446dis_crimi_nates
disqualifies2552496dis_quali__fies
dissimilates15125196dis__simi_lates
distillates1246156dis__til__lates
disulfates14145366dis__u_l__fates
equilibrant2282586___equilibra_nt
equilibrating2562206___equilibrating
equilibration2462366___equilibration
equilibrations2561976___equilibrations
equilibratory2761676___equilibratory
equilibrists2362286___equilibrists
equilibriums2581886___equilibriums
nonequilibriums28191326nonequilibriums
recalibrates1663466__re_calibrates
semiliterates1552376__se_militerates
sequestrates2152486__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.343520965.0
2DLD Change Limit95024337.81312162.3
3Display Results33330.0301100.0
 (SQL Overall)178691338.18621828.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.