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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

135 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
collateralities17152331collateralities_
collateralizes2572483collaterali_zes_
collaterality1862564collateralit___y
collateralize2472694collaterali_ze__
collateralized2672124collaterali_ze_d
collateralizing2762064collateralizi_ng
connaturalities17162604connaturalities_
collaterals1353385collateral____s_
collegialities1763045coll_egialities_
collinearities1662175colline_arities_
colloquialities2671885colloquialities_
illiberalities1662445_illiberalities_
literalities1267545___literalities_
centralities1448626c__ent_ralities_
coevalities1646806co____evalities_
coilabilities1748096coila__bilities_
colinearities1553716co_line_arities_
collaborates1673686collabora__t_es_
collaboratives21101946collaborati_ves_
collateral1244116collateral______
collaterally1752826collateral____ly
compatibilities2363626compatibilities_
confraternities2091546confrater_nities_
coplanarities1752666copla__narities_
corporalities1755296co__rporalities_
corporealities1863206corpore_alities_
illegalities1353886_ill__egalities_
immaterialities1962876_immaterialities_
lateralizes2048436___laterali_zes_
liberalities1446266___liberalities_
materialities1566396___materialities_
polytonalities1982746po_lytonalities_
volatilities1546516vo_lat__ilities_
alliterates11106267_allitera__t_es_
alterabilities1667337__al_terabilities_
alterities10411067__al_ter__ities_
amoralities1347427____amoralities_
atonalities1148417____atonalities_
auralities10410227____a_uralities_
bilateralism1653707_bilateral__i_sm
bilateralisms1763317_bilaterali_sms_
carnalities1348787c___a_rnalities_
causalities1346227c___a_usalities_
celerities1289777c_el__er__ities_
cellularities1562407cell__ularities_
chiralities1646517c____hiralities_
clarities11312487c__la__r__ities_
classicalities1862537c_lassicalities_
clathrates1545287c__lathra__t_es_
cleanabilities1856057c_leanabilities_
coelenterates1552867coelentera__t_es_
coequalities2355567co___equalities_
colemanites1544707co_l__emanit_es_
collaborate1593967collabora__t_e__
collaborated1772817collabora__t_e_d
collaborating1852587collabora__ti_ng
collaboration1763007collabora__ti_on
collaborations1872747collabora__tions
collaborative2092387collabora__ti_ve
collaboratively2571547collaborati_vely
collaborators17142077collabora__tors_
collagenases1552157collagena___ses_
collarless1243077colla__r_l___ess
collectivities2174167coll_ectivities_
collieries1248347coll_ier____ies_
comicalities1846977co___micalities_
commercialities2363317commercialities_
commonalities1965157co__mmonalities_
communalities1954847co__mmunalities_
comparabilities2374377comparabilities_
computabilities2354547computabilities_
concatenates1654537concatena__t_es_
conceptualities2174297conceptualities_
congenialities1774197co_ngenialities_
conjugalities2353007co__njugalities_
connaturality1872477connaturalit___y
connubialities1862597co_nnubialities_
contrarieties1563817co__nt_rarieties_
convivialities2262777co_nvivialities_
cordialities1546157co___rdialities_
countabilities1856697co_untabilities_
counterrallies1683957co_unterral_lies_
criticalities1754687c__riticalities_
culpabilities1946027culpa__bilities_
cyclicalities1953037cycl__icalities_
dilatabilities1795947_dilatabilities_
elaterites1048287__elater__it_es_
ephemeralities2171787_ephemeralities_
externalities2055187___externalities_
extralities1848237___ext_ralities_
fatalities1349447___fat__alities_
filterabilities2053287_fil_terabilities_
fraternities1552947__frater_nities_
generalities1347017___generalities_
hospitalities1854127hospit__alities_
illiteracies1453307_illitera__cies_
illiterates11115657_illitera__t_es_
illogicalities17132527_illogicalities_
integralities1495517___integralities_
internalities1358637___internalities_
labialities1347037___la_bialities_
lateralize1949057___laterali_ze__
lateralized2147407___laterali_ze_d
lateralizing2257057___lateralizi_ng
laterites9715087___later__it_es_
legalities1148917___l__egalities_
lethalities1446417___let_halities_
linealities1148227___line_alities_
literalizes2048117___literali_zes_
maternities1346017___mater_nities_
molalities121110287mo_l____alities_
molarities12129437mo_la__r__ities_
moralities121111927mo_____ralities_
mortalities1348427mo__rt__alities_
natalities10410667___nat__alities_
neutralities1246467__neut_ralities_
nonlinearities1462427nonline_arities_
nonliterates1255457nonlitera__t_es_
obliterates1345127_oblitera__t_es_
optimalities1654667_o__ptimalities_
oralities91214127_o_____ralities_
palatabilities1846807_palatabilities_
paternities1345797___pater_nities_
pluralities1345687__pl__uralities_
polarities121211777po_la__r__ities_
posterities1369047po__ster__ities_
potentialities1674207potent_ialities_
quaternities2152517__quater_nities_
solderabilities1873377so_l_derabilities_
solvabilities1846897solva__bilities_
spatialities1465567__spat_ialities_
sterilities11129017____sterilities_
tolerabilities16116607to_l__erabilities_
totalities101210787to___t__alities_
waterlilies1453497___water_lilies_

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.360496363.9
2DLD Change Limit950241358.97010593.5
3Display Results1351350.1101227.3
 (SQL Overall)1786911359.44018929.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.