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
reconciliations195374(None) 
reconciliation1854121reconciliation_
conciliations1747202__conciliations
conciliation1648233__conciliation_
recompilations2054943recompil_ations
reconciliatory2161633reconciliat_ory
reconfirmations2283083reconfirmations
conciliating1775614__conciliati_ng
conciliators1695394__conciliat_ors
recalculations18104034recalcul_ations
recanalizations2657464recanalizations
recirculations1884224recircul_ations
recodifications23165454reco_difications
recombinations2095584recombi_nations
recompilation1955154recompil_ation_
reconceptions1965124reconc__eptions
reconditions1546824recon__di_tions
reconfirmation2153224reconfirmation_
reconsecrations1995104reconsecrations
reconvictions2054874recon__victions
reinoculations1653924reinocul_ations
remobilizations2855494remo_bilizations
renunciations1554854renunc__iations
brecciations1844285brec__c__iations
cancelations1657095__cancel_ations
cancellations1754395__cancellations
cantillations1545735__cantillations
ciliations121111005_____ciliations
compilations1848675__compil_ations
conciliates1546885__conciliat__es
conciliative1954165__conciliati_ve
conciliator1595595__conciliat_o_r
conciliatory1994215__conciliat_ory
confirmations2055675__confirmations
confiscations2044955__confiscations
conflations16411145__con_fl_ations
conflictions1945225__con_flictions
congelations1549735__congel_ations
consignations16105935__consignations
consociations1747515__consociations
consolations1449735__consol_ations
consolidations1754745__consolidations
consultations1546935__consultations
continuations1547145__continuations
decollations1547365deco___llations
deconditions1645285decon__di_tions
deconsecrations2064515deconsecrations
decortications1966775decorti_cations
defoliations1647595defo___liations
deionizations2349215deion_i_zations
delocalizations27137005delo_calizations
demobilizations2955495demo_bilizations
demonizations25410245demon_i_zations
denunciations1653885denunc__iations
domiciliations1992535_domiciliations
emancipations1953745_emanci_pations
enunciations1445095_enunc__iations
oscillations1445115___oscillations
precancellation2161165precancellation_
preconceptions2253885preconc__eptions
preconditions1854895precon__di_tions
preconvictions2353355precon__victions
reanimations1468785re_an_i_mations
recalculation17114595recalcul_ation_
recalibrations1853695rec_alibrations
recanalization2557675recanalization_
recantations1448875recan___tations
recirculation1764905recircul_ation_
recitations13314205re___ci_tations
recodification22125665reco_dification_
recognitions1544855reco__gni_tions
recollections1754725reco__llections
recolonizations26165765recolonizations
recombination19106175recombi_nation_
recommendations22113095recommendations
recompositions2053175recomposi_tions
recomputations20104105reco_mputations
reconcentration1963995reconcentration_
reconception1855645reconc__eption_
reconciling1645485reconcil___i_ng
recondition1447125recon__di_tion_
reconfiguration2162055reconfiguration_
reconnections1765755recon__nections
reconsecration1885565reconsecration_
reconsideration18112585reconsideration_
reconsolidating1962015reconsolidati_ng
reconstitutions1763275reconstitutions
reconstructions19124735reconstructions
recontamination1983545recontamination_
reconviction1955085recon__viction_
recordations1548645reco___rdations
recriminations1856725recrimi_nations
rectifications2148915rectifi_cations
redistillations1672915redistillations
reescalations1573785re_escal_ations
reformulations1953555reformul_ations
rehabilitations2053035re_habilitations
reincarnations1672785re_incarnations
reinflations1546645re_in_fl_ations
reinoculation1554425reinocul_ation_
relocations13311145relo_c___ations
remobilization2755695remo_bilization_
remonetizations2655775remonetizations
remonstrations16116485remon_strations
remotivations1846695remo_ti_vations
renominations15108305reno_mi_nations
renunciation1455315renunc__iation_
reoccupations1972765re_o_ccupations
reoxidations2046045re_o_xi_dations
repopulations1765325repo_pul_ations
repunctuations1852265repunc_tuations
resocialization2664345reso_cialization_
resuscitations1673785resusci_tations
retaliations12511405re___taliations
reticulations1556615re_ticul_ations
reunifications19136915re_un_ifications
reutilizations2348715re__utilizations
revaccinations2153615revacci_nations
revocations16410315revo_c___ations
scintillations1662755_scintillations
ventilations1547405ve__ntil_ations

Search took 5 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 Limit658741214.43614849.9
3Display Results1211210.0801512.5
 (SQL Overall)1786911214.60938770.0
 
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.