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

97 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
controllability22121841controllability_
contractibility2462585contractibility_
controllable1653075controllab_l___e
coagulability2153326co__agulability_
coilability1847936c____oilability_
conceivability2663266con_ceivability_
confirmability2662596con_firmability_
contemptibility2691936contemptibility_
contractility2074076contr__actility_
countability1956586count____ability_
crossability1956106c___rossability_
drillability1854646___drillability_
honorability2055816hon__o_rability_
intolerability1964526_int_olerability_
intractability2155866_intractability_
inviolability2155116_invio_lability_
monosyllabicity2781026monosyllabicity_
nonavailability2371956nonavailability_
uncontrollably21101656uncontrollab_l__y_
unreliability1855606_un_reliability_
castability1848417cast____ability_
centrality1547747centr___a__lity_
codifiability2473637co__difiability_
communicability2862517communicability_
comparability2454907co__mparability_
compensability2563537co_mpensability_
compressibility2672557compressibility_
computability2455157co__mputability_
conductibility2462817con_ductibility_
contrariety1654637contr___ari_ety_
contrarily1576107contr___aril__y_
controllership21182207controllershi__p
controllerships22132037controllershi_ps
controlling1445427contro_l___li_ng
convertibility2463277con_vertibility_
corrigibility2163317co__rrigibility_
corruptibility2362387co_rruptibility_
culpability2045297c____ulpability_
cultivability2373687cult__ivability_
curability1747867c__ur___ability_
cutability1747867c_ut____ability_
detonability1856147_det_o_nability_
enforceability2472557_enforceability_
extractability28103557_extractability_
extrudability2673147_extr_udability_
forgeability2154577fo__r_geability_
formability2146967fo__r__mability_
formidability2463997fo__rmidability_
improbability2464407_impro_bability_
improvability2564597_impro_vability_
incontrollable18201837incontrollab_l___e
inexorability2585467_inexo_rability_
infallibility2164307_in_fallibility_
insociability2056227_in_sociability_
insolubility1754097_in_so_lubility_
integrability1956587_int_egrability_
manipulability2362037man_ipulability_
modulability2064217mo___dulability_
negotiability1994407__negotiability_
nonflammability2771517nonflammability_
notability1549707__n__o_tability_
obtainability2053577_obt_ainability_
operability1848857_oper___ability_
opposability2154397_o_ppo_sability_
overstability21125377_over_stability_
penetrability2055217penetr___ability_
polarizability3062507polar_izability_
portability1849567po__r__tability_
potability1749817po_t____ability_
probability2047707___pro_bability_
recallability2054507__recallability_
reconcilability2492417recon__cilability_
reliability1649467____reliability_
rentability16410197rent____ability_
retrievability2252907_retrievability_
roadability1757207____roadability_
sinterability1855217sint__erability_
solvability1946417____solvability_
sorbability1846377so__r__bability_
thermolability2462747_thermolability_
tolerability1776297___t_olerability_
traceability1956537___traceability_
tractability1947097___tractability_
trainability1746857___trainability_
treatability1747437___treatability_
trustability1756137___trustability_
unavailability2263627_unavailability_
uncontrollable18172167uncontrollab_l___e
unknowability2572347_unkno_wability_
unsociability2054897_un_sociability_
untenability1756427_unt__enability_
unthinkability2662357_unthinkability_
untouchability2462287_untouchability_
unworkability2552907_un_workability_
venerability2046777vener___ability_
violability1946287___vio_lability_
workability2345387wo__r__kability_

Search took 10 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 Limit95024979.22010306.3
3Display Results97970.0801212.5
 (SQL Overall)178691979.65618505.7
 
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.