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

39 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
adjustability265298(None) 
adaptability2055223ad_aptability
adjustabilities2563253adjustabilities
adoptability2054763ad_optability
advisability2155063advis_ability
trustability1756133_trustability
acceptability2454124acceptability
accountability2362614accountability
actability1749084a___ctability
addressability2172174addressability
adjustable2042444adjustab_l__e
admirability2055714ad_mirability
admissibility2183124admissibility
adorability1746904ad__orability
affectability2663854affectability
assumability1954024assu_mability
brushability2253784_brushability
castability1848414__castability
countability1956584_countability
cutability1747864__cu_tability
dilatability1845454_dilatability
disability1649774_d_is_ability
durability1647734_d_u_rability
educability1946244ed_u_cability
equitability2645774_equitability
immutability2155894immu_tability
imputability2146384impu_tability
instability1649444__instability
metastability2055574metastability
mutability1748074__mu_tability
overstability21125374overstability
quotability2555594__quotability
reputability1946984repu_tability
reusability1648474_reus_ability
stability14410084____stability
suitability1647114__suitability
testability1648804__testability
unsuitability1865134unsuitability
usability1447164___us_ability

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.376475242.0
2DLD Change Limit95024394.98319069.6
3Display Results39390.0162437.5
 (SQL Overall)178691395.37533244.8
 
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.