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 “recalcitrancy” 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.

62 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
recalcitrancy1911107(None) 
recalcitrance1671601recalcitrance
recalcitrances1781432recalcitrances
recalcitrant1661772recalcitran_t
recalcitrants1761272recalcitrants
recalcitrancies1811973recalcitrancies
precipitancy2362525prec_ipit_ancy
reactance1346355re_a_c_t_ance
recalibrate1553675recal_ibra_te
recalibrated1753185recal_ibrated
recalibrates1663465recal_ibrates
reluctancy17132805re__luct_ancy
aliteracy1444336___al_itera_cy
calcitic1148196__calcit__ic_
calcitonin1453926__calcit_onin
calligraphy2262566__calligraphy
capacitance1651906__capacit_ance
decalcify2041946decalci____fy
decalcifying2452186decalcifyin_g
decalcomania1961366decalc_omania
expectancy2692486_expec_t_ancy
exultancy21142726_exul__t_ancy
hesitancy1743546he___sit_ancy
inhabitancy2152046inha_bit_ancy
malignancy1851856__mal_ignancy
mesalliance1551956mesalli__ance
militancy1644126__mil_it_ancy
oscitancy16122846___oscit_ancy
peccancy1643956pec__c___ancy
precipitance2053136prec_ipit_ance
preclearance1852336prec_l_earance
racetrack1743496r__a_cetra_ck
radiancy1445336r__a_di__ancy
reactances1446146re_a_c_t_ances
reactant10311436re_a_c_t_an_t
reactants1146626re_a_c_t_ants
reactionary1653696re_a_ctionary
reality10313576re_al_it____y
reappearance1882036re_appearance
reassurance13142756re_a_ssurance
rebalance1345766rebal____ance
recalculate15135386recalc_ula_te
recalculated17154626recalc_ulated
recalculates16164866recalc_ulates
recalibrating1852966recal_ibrating
recalibration1754436recal_ibration
recalling122211906recalli___n_g
recognizance2662176recogni_zance
recreancy1643786re___c_reancy
recusancy1643746re___c_usancy
reentrance1245466re___entrance
reflectance1852866re_flect_ance
regality1249316regal_it____y
relevancy17134046re__l__evancy
reliance10310476re__l_i__ance
reluctance14114286re__luct_ance
remittance1444456re___mittance
remonstrance1653396re_monstrance
renaissance1372036rena__issance
renitency1445446re___nit_ency
resiliency1573316resil_i__ency
valiancy1674816__val_i__ancy

Search took 16 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 Filter1786911488190.436409841.7
2DLD Change Limit1488196214.73610099.0
3Display Results62620.0461347.8
 (SQL Overall)1786916215.21811742.1
 
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.