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

42 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
spreadabilities2054001spreadabilities_
readabilities1649313__readabilities_
appealabilities2163884appealabilities_
pregnabilities1956574_pregnabilities_
roadabilities1647814__roadabilities_
spreadability2154404spreadabilit___y
treatabilities1657624_treatabilities_
upgradabilities2162484upgradabilities_
agreeabilities1755345agre_eabilities_
bearabilities1748675__bearabilities_
breathabilities2254015_breathabilities_
cleanabilities1856055_cleanabilities_
credibilities1856075_cre_dibilities_
dependabilities2155245dependabilities_
drapabilities1847115_dr_apabilities_
erasabilities1549635_er_asabilities_
expendabilities2774375expendabilities_
extendabilities2564165extendabilities_
formidabilities2353375formidabilities_
openabilities1748625op_e_nabilities_
operabilities17510055op_e_rabilities_
palatabilities1846805_palatabilities_
permeabilities2056845_permeabilities_
placabilities1947635_p_lacabilities_
playabilities2046615_p_layabilities_
preferabilities2254615_preferabilities_
printabilities1847325_printabilities_
probabilities1958105_pr_obabilities_
reliabilities15410465__reliabilities_
rentabilities15411265__rentabilities_
repeatabilities1955915repeatabilities_
reusabilities1549285__reusabilities_
salabilities1449615s___alabilities_
separabilities1847345s_eparabilities_
severabilities1947435seve_rabilities_
sewabilities1748935s__e_wabilities_
shareabilities1955215share__abilities_
sorbabilities1746995sor__babilities_
squeezabilities3562305squeezabilities_
survivabilities2352715survivabilities_
unreliabilities1754795unreliabilities_
wearabilities1848415__wearabilities_

Search took 4 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 Filter178691435480.296603685.8
2DLD Change Limit43548422.72016010.3
3Display Results42420.0301400.0
 (SQL Overall)178691423.04658664.1
 
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.