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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
reconfiguration2162051reconfiguration_
configuration1954133__configuration_
configurational2162203__configurational
configurations2063703__configurations
reconfiguring2061634reconfigur__i_ng
reconfirmation2153224reconfi_rmation_
reconfirmations2283084reconfi_rmations
reconsideration18112584reconsideration_
configurative2262815__configurati_ve
prefiguration1953455pre___figuration_
prefigurations2053025pre___figurations
reconcentration1963995reconcentration_
reconciliation1854125reconci_liation_
reconciliations1953745reconci_liations
reconsecration1885565recon_secration_
reconsecrations1995105recon_secrations
reinvigoration18152715re_invigoration_
reinvigorations19152415re_invigorations
confabulation2063306__confabulation_
confabulations2162806__confabulations
confederation1995256__confederation_
confederations20104606__confederations
configuring1853156__configur__i_ng
confirmation1946186__confi_rmation_
confirmational21153396__confi_rmational
confirmations2055676__confi_rmations
confiscation1945536__confi_scation_
confiscations2044956__confi_scations
conflagration1953016__conflagration_
conflagrations2052726__conflagrations
confutation1668726__conf__utation_
confutations1767796__conf__utations
conjuration2049516__con__juration_
conjurations2148496__con__jurations
consideration1655526__consideration_
considerations1764846__considerations
consignation15136316__consig_nation_
consignations16105936__consig_nations
continuation1448196__continu_ation_
continuations1547146__continu_ations
deconcentration20103626deconcentration_
deconsecration1954786decon_secration_
deconsecrations2064516decon_secrations
denigration1348466de__n_ig_ration_
denigrations1447356de__n_ig_rations
figuration1445916_____figuration_
figurations1545086_____figurations
inconsideration1871866inconsideration_
nonfigurative2062826__nonfigurati_ve
recalibration1754436rec_ali_bration_
recalibrations1853696rec_ali_brations
recapitulation1862496rec_apitulation_
recapitulations1972396rec_apitulations
recodification22125666reco_dification_
recodifications23165456reco_difications
recombination19106176recombi__nation_
recombinational21102026recombi__national
recombinations2095596recombi__nations
recompilation1955156recompi__lation_
recompilations2054956recompi__lations
recomputation1974396reco__mputation_
recomputations20104106reco__mputations
reconcentrating2063346reconcentrati_ng
recondition1447126recondi____tion_
reconditions1546826recondi____tions
reconfigure1752286reconfigur_____e
reconfigured1951946reconfigur____ed
reconfigures1852196reconfigur____es
reconfirming2053086reconfi__r_mi_ng
reconsecrating1954196recon_secrati_ng
reconstitution1663566reconstitu__tion_
reconstitutions1763276reconstitu__tions
reconstruction1894776reconstru_ction_
reconstructions19124736reconstru_ctions
recontamination1983546recontamination_
reconviction1955086reconvi___ction_
reconvictions2054876reconvi___ctions
rectification2049516rectifi__cation_
rectifications2148916rectifi__cations
redintegration16153646redinteg_ration_
redintegrations17143256redinteg_rations
refrigeration1764156re__frigeration_
refrigerations1863776re__frigerations
reintegration14175376re_integ_ration_
reintegrations15164786re_integ_rations
reinvigorating1962136re_invigorati_ng
remigration14228916re___mig_ration_
remigrations15227796re___mig_rations
remonstration15117126remon__stration_
remonstrations16116486remon__strations
renaturation1256756re__n_aturation_
renaturations1355966re__n_aturations
transfiguration1962226transfiguration_

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.310576422.6
2DLD Change Limit65874934.86013554.3
3Display Results93930.0801162.5
 (SQL Overall)178691935.25034036.4
 
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.