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

133 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
reaffirmation215206(None) 
reaffirmations2251971reaffirmations
affirmation1953682__affirmation
affirmations2053233__affirmations
reanimation1359633rea_ni_mation
reconfirmation2153223reconfirmation
reformation1648413re__formation
affiliation1744854__affiliation
affirmative2253094__affirmative
affixation2344394__affi_xation
confirmation1946184_confirmation
deformation1747664de__formation
malformation1953324_malformation
preformation1946474pre__formation
reactivation17176954reacti_vation
reaffirming2051924reaffirm__ing
reafforestation21101474reafforestation
realization20417224rea_li_zation
reanimations1468784rea_ni_mations
reconfirmations2283084reconfirmations
reformations1747604re__formations
reification16412904re_ifi_cation
respiration13511194re_spir_ation
admiration1347735__admir_ation
affectation1943845__affectation
affiliations1844185__affiliations
affirmatives2352155__affirmatives
affixations2443855__affi_xations
animation11313685__a_ni_mation
aspiration1249995__aspir_ation
beatification20138075beatification
beneficiation20162555beneficiation
confirmations2055675_confirmations
conformation1947325_conformation
deactivation18156085deacti_vation
deaeration11313015dea__er_ation
deamination14411545dea_mi_nation
decimation15411625de__ci_mation
defamation1646845de__f_amation
defloration1547265de_flor_ation
deformations1846845de__formations
deification17411665de_ifi_cation
disaffiliation2163335disaffiliation
edification1749355_edifi_cation
eradication14410115era_di_cation
estimation12410845_e_sti_mation
expiration19610715_e_xpir_ation
extirpation2084925_e_xtirpation
flirtation1354825___flirtation
formation1439425____formation
information16147715__information
lacrimation1546265_lacri_mation
legitimation1555165legiti_mation
malformations2053075_malformations
officiation1943835__officiation
perforation1649005pe_rfor_ation
perspiration1656835perspir_ation
prefabrication2392825prefabrication
preformations2045715pre__formations
radiation10313395r_a_di__ation
ramification1998215r_amification
ratification17810665r_atification
reactivations18176145reacti_vations
reaffirm1642485reaffirm_____
reaffirmed1951505reaffirm___ed
reaffirms1741945reaffirm____s
reafforesting2051395reafforesting
reaggregation1653145reaggregation
realizations21415535rea_li_zations
reallocation1454495rea_llocation
reanimating1447235rea_ni_mating
reannexation1953165rea_nnexation
reapplication1954725reapplication
reapportion1554035reappor__tion
reassertion1154025reasser__tion
reattribution15112525reattribution
recalibration1754435recalibration
recitation12315945re__ci_tation
reclamation1546355re__clamation
recordation1449265re__cordation
recreation12413615re___creation
rectification2049515rectification
recuperation1656725recuper_ation
redecoration1546015redecor_ation
rededication1646505rededi_cation
redefinition1652525redefi_nition
redirection1446055re__direction
reexportation2253145reexportation
reflation12412335re__f__lation
reformational18113425re__formational
reformative1945675re__formative
reformulation1853975re__formulation
refoundation16102795re_foundation
refraction15137905re__f_raction
refrigeration1764155re_frigeration
refutation1349915re__f_utation
regeneration1348195regener_ation
registration1347535registr_ation
rehydration1844645re_hydr_ation
reifications17411825re_ifi_cations
reimportation17114035reimportation
reincarnation1563175reincarnation
reinfestation1664255reinfestation
reinflation1447205reinf__lation
reinnervation1653625reinnervation
reiteration11412165re_iter_ation
relubrication1754505relubrication
remediation1449215remedi__ation
remigration14228915re__migration
remotivation1747435remoti_vation
remuneration1446935remuner_ation
renaturation1256755renatur_ation
renomination1499185renomi_nation
reoperation13410905re_oper_ation
reoxidation1946655re_oxi_dation
reparation12612725re__par_ation
repatriation14126975re_patriation
replication15712015re_pli_cation
repudiation14107605repudi__ation
reradiation12410155reradi__ation
reservation1489145re__servation
resignation1247475re__signation
respirations14410305re_spir_ations
restoration11412095re_stor_ation
retaliation11612325retali__ation
retardation12106865re__tardation
reunification18147455reunification
revaccination2053865revacci_nation
revalidation1657945revali_dation
revalorization2664835revalorization
suffixation2452865_suffi_xation
transformation1963075transformation
verification201810645verifi_cation

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901338.81314159.8
3Display Results1331330.0931430.1
 (SQL Overall)1786911339.29619222.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.