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

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

121 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
reconciliations195373(None) 
reconciliation1854111reconciliation_
conciliations1747192__conciliations
conciliation1648233__conciliation_
recompilations2054933recompil_ations
reconciliatory2161623reconciliat_ory
reconfirmations2283083reconfirmations
conciliating1775604__conciliati_ng
conciliators1695384__conciliat_ors
recalculations18104034recalcul_ations
recanalizations2657464recanalizations
recirculations1884224recircul_ations
recodifications23165454reco_difications
recombinations2095584recombi_nations
recompilation1955154recompil_ation_
reconceptions1965094reconc__eptions
reconditions1546814recon__di_tions
reconfirmation2153224reconfirmation_
reconsecrations1995084reconsecrations
reconvictions2054874recon__victions
reinoculations1653924reinocul_ations
remobilizations2855494remo_bilizations
renunciations1554854renunc__iations
brecciations1844275brec__c__iations
cancelations1657085__cancel_ations
cancellations1754395__cancellations
cantillations1545735__cantillations
ciliations121110995_____ciliations
compilations1848665__compil_ations
conciliates1546885__conciliat__es
conciliative1954165__conciliati_ve
conciliator1595585__conciliat_o_r
conciliatory1994205__conciliat_ory
confirmations2055675__confirmations
confiscations2044955__confiscations
conflations16411135__con_fl_ations
conflictions1945225__con_flictions
congelations1549725__congel_ations
consignations16105935__consignations
consociations1747505__consociations
consolations1449725__consol_ations
consolidations1754735__consolidations
consultations1546935__consultations
continuations1547145__continuations
decollations1547355deco___llations
deconditions1645275decon__di_tions
deconsecrations2064495deconsecrations
decortications1966765decorti_cations
defoliations1647585defo___liations
deionizations2349195deion_i_zations
delocalizations27137005delo_calizations
demobilizations2955485demo_bilizations
demonizations25410225demon_i_zations
denunciations1653885denunc__iations
domiciliations1992535_domiciliations
emancipations1953745_emanci_pations
enunciations1445095_enunc__iations
oscillations1445115___oscillations
precancellation2161165precancellation_
preconceptions2253845preconc__eptions
preconditions1854885precon__di_tions
preconvictions2353355precon__victions
reanimations1468785re_an_i_mations
recalculation17114595recalcul_ation_
recalibrations1853695rec_alibrations
recanalization2557675recanalization_
recantations1448875recan___tations
recirculation1764905recircul_ation_
recitations13314195re___ci_tations
recodification22125665reco_dification_
recognitions1544855reco__gni_tions
recollections1754725reco__llections
recolonizations26165765recolonizations
recombination19106175recombi_nation_
recommendations22113075recommendations
recompositions2053165recomposi_tions
recomputations20104085reco_mputations
reconcentration1963985reconcentration_
reconception1855625reconc__eption_
reconciling1645475reconcil___i_ng
recondition1447125recon__di_tion_
reconfiguration2162055reconfiguration_
reconnections1765745recon__nections
reconsecration1885555reconsecration_
reconsideration18112585reconsideration_
reconsolidating1962005reconsolidati_ng
reconstitutions1763265reconstitutions
reconstructions19124725reconstructions
recontamination1983545recontamination_
reconviction1955085recon__viction_
recordations1548625reco___rdations
recriminations1856725recrimi_nations
rectifications2148915rectifi_cations
redistillations1672915redistillations
reescalations1573785re_escal_ations
reformulations1953555reformul_ations
rehabilitations2053035re_habilitations
reincarnations1672785re_incarnations
reinflations1546645re_in_fl_ations
reinoculation1554425reinocul_ation_
relocations13311135relo_c___ations
remobilization2755695remo_bilization_
remonetizations2655765remonetizations
remonstrations16116485remon_strations
remotivations1846685remo_ti_vations
renominations15108295reno_mi_nations
renunciation1455315renunc__iation_
reoccupations1972765re_o_ccupations
reoxidations2046045re_o_xi_dations
repopulations1765325repo_pul_ations
repunctuations1852255repunc_tuations
resocialization2664335reso_cialization_
resuscitations1673785resusci_tations
retaliations12511405re___taliations
reticulations1556615re_ticul_ations
reunifications19136915re_un_ifications
reutilizations2348715re__utilizations
revaccinations2153615revacci_nations
revocations16410305revo_c___ations
scintillations1662755_scintillations
ventilations1547405ve__ntil_ations

Search took 7 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.0931921408.6
2DLD Change Limit658741215.89011184.0
3Display Results1211210.0761592.1
 (SQL Overall)1786911216.05929491.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.