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

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

124 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
reconciliations1953741reconciliations_
reconciliation1854122reconciliation__
conciliations1747203__conciliations_
conciliation1648234__conciliation__
recompilations2054954recompil_ations_
reconciliatory2161634reconciliat_o_ry
reconfirmations2283084reconfirmations_
conciliating1775615__conciliati_n_g
conciliators1695395__conciliat_ors_
recalculations18104035recalcul_ations_
recanalizations2657465recanalizations_
recirculations1884225recircul_ations_
recodifications23165455reco_difications_
recombinations2095595recombi_nations_
recompilation1955155recompil_ation__
reconceptions1965125reconc__eptions_
reconditions1546825recon__di_tions_
reconfirmation2153225reconfirmation__
reconsecrations1995105reconsecrations_
reconvictions2054875recon__victions_
reinoculations1653925reinocul_ations_
remobilizations2855495remo_bilizations_
renunciations1554855renunc__iations_
brecciations1844286brec__c__iations_
cancelations1657096__cancel_ations_
cancellations1754396__cancellations_
cantillations1545736__cantillations_
ciliations121111006_____ciliations_
compilations1848686__compil_ations_
conciliates1546886__conciliat__es_
conciliative1954166__conciliati__ve
conciliator1595596__conciliat_o__r
conciliatory1994216__conciliat_o_ry
confirmations2055676__confirmations_
confiscations2044956__confiscations_
conflations16411146__con_fl_ations_
conflictions1945226__con_flictions_
congelations1549736__congel_ations_
consignations16105936__consignations_
consociations1747516__consociations_
consolations1449746__consol_ations_
consolidations1754746__consolidations_
consultations1546936__consultations_
continuations1547146__continuations_
decollations1547366deco___llations_
deconditions1645286decon__di_tions_
deconsecrations2064516deconsecrations_
decortications1966776decorti_cations_
defoliations1647596defo___liations_
deionizations2349216deion_i_zations_
delocalizations27137006delo_calizations_
demobilizations2955496demo_bilizations_
demonizations25410246demon_i_zations_
denunciations1653886denunc__iations_
domiciliations1992536_domiciliations_
emancipations1953746_emanci_pations_
enunciations1445096_enunc__iations_
oscillations1445116___oscillations_
precancellation2161166precancellation__
preconceptions2253886preconc__eptions_
preconditions1854896precon__di_tions_
preconvictions2353356precon__victions_
reanimations1468786re_an_i_mations_
recalculation17114596recalcul_ation__
recalibrations1853696rec_alibrations_
recanalization2557676recanalization__
recantations1448876recan___tations_
recirculation1764906recircul_ation__
recitations13314206re___ci_tations_
recodification22125666reco_dification__
recognitions1544856reco__gni_tions_
recollections1754726reco__llections_
recolonizations26165766recolonizations_
recombination19106176recombi_nation__
recombinational21102026recombi_national
recommendations22113096recommendations_
recompositions2053176recomposi_tions_
recomputations20104106reco_mputations_
reconcentration1963996reconcentration__
reconception1855646reconc__eption__
reconcilability2492416reconcil_ability
reconciling1645486reconcil___i_n_g
recondition1447126recon__di_tion__
reconditioned1783276recon__di_tioned
reconfiguration2162056reconfiguration__
reconnections1765756recon__nections_
reconsecration1885566reconsecration__
reconsideration18112586reconsideration__
reconsolidating1962016reconsolidati_n_g
reconstitutions1763276reconstitutions_
reconstructions19124736reconstructions_
recontamination1983546recontamination__
reconviction1955086recon__viction__
recordations1548646reco___rdations_
recriminations1856726recrimi_nations_
rectifications2148916rectifi_cations_
redistillations1672916redistillations_
reescalations1573786re_escal_ations_
reformulations1953556reformul_ations_
rehabilitations2053036re_habilitations_
reincarnations1672786re_incarnations_
reinflations1546646re_in_fl_ations_
reinoculation1554426reinocul_ation__
relocations13311146relo_c___ations_
remobilization2755696remo_bilization__
remonetizations2655776remonetizations_
remonstrations16116486remon_strations_
remotivations1846696remo_ti_vations_
renominations15108306reno_mi_nations_
renunciation1455316renunc__iation__
reoccupations1972766re_o_ccupations_
reoxidations2046046re_o_xi_dations_
repopulations1765336repo_pul_ations_
repunctuations1852266repunc_tuations_
resocialization2664346reso_cialization__
resuscitations1673786resusci_tations_
retaliations12511406re___taliations_
reticulations1556616re_ticul_ations_
reunifications19136916re_un_ifications_
reutilizations2348716re__utilizations_
revaccinations2153616revacci_nations_
revocations16410316revo_c___ations_
scintillations1662756_scintillations_
ventilations1547406ve__ntil_ations_

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 Filter178691658740.326548131.9
2DLD Change Limit658741245.20312660.8
3Display Results1241240.0931333.3
 (SQL Overall)1786911245.62231784.2
 
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.