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

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

200 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
preservationist2062801preservationist_
reservationist17114332_reservationist_
reservationists1873692_reservationists
preservations1895543preservation_s__
conservationist2084024conservationist_
preformationist2272224preformationist_
preservation1776284preservation____
reservations1588584_reservation_s__
prerevisionist19102525prere_visionist_
presentations1548135presentation_s__
preservability2453345preservabi_li_ty
preservatives2152785preservati_ves__
recreationist1555745_re_creationist_
recreationists1664375_re_creationists
reservation1489145_reservation____
restrictionist1665045_restrictionist_
restrictionists1764085_restrictionists
conservations1849096conservation_s__
cooperationist1864226cooper_ationist_
cooperationists1963196cooper_ationists
creationist1379236cr__e__ationist_
creationists1476626cr__e__ationists
denervations1657096_denervation_s__
destructionist17104966_destructionist_
destructionists1894226_destructionists
enervations1478576__enervation_s__
liberationist15124736_liber_ationist_
liberationists16143696_liber_ationists
observations1785016_observation_s__
operationist1457946__oper_ationist_
operationists1556056__oper_ationists
perfectionist2055336perfe__ctionist_
perfectionists2164016perfe__ctionists
preformations2045716preformation_s__
preparations1648316prepar_ation_s__
prescriptions19135336prescription_s__
preselections17144446preselection_s__
presentation1448996presentation____
presentational1673216presentation__al
preservative2053956preservat___i_ve
projectionist2485256proje__ctionist_
projectionists2594116proje__ctionists
prostrations1449766prostr_ation_s__
protectionist17116686prote__ctionist_
protectionists18105146prote__ctionists
receptionist1656406_rece__ptionist_
receptionists1754776_rece__ptionists
repudiationist17183186_repudiationist_
repudiationists18212636_repudiationists
restrictionism1863786_restrictionis_m
restrictionisms1963246_restrictionisms
resurrectionist1762836_resurrectionist_
salvationist1554406___salvationist_
salvationists1653566___salvationists
segregationist1692916_segregationist_
segregationists17122296_segregationists
separationist1555276_separ_ationist_
separationists1664086_separ_ationists
abstractionist18133867_abstractionist_
abstractionists19143307_abstractionists
aestivations1547487_aestivation_s__
annexationist20233037_anne_xationist_
annexationists21192577_anne_xationists
associationist16173357_associationist_
associationists17183077_associationists
coacervations2053877coacervation_s__
conservation1749407conservation____
conservational1955347conservation__al
constructionist1984037constructionist_
creationism1576467cr__e__ationis_m
creationisms1685527cr__e__ationisms
crenelations1446187crene_lation_s__
crenellations1553577crenellation_s__
deaerations12311677_deaer_ation_s__
denervation1567947_denervation____
desecrations1559217_desecration_s__
desertions1139887_deser__tion_s__
desperations1559527_desper_ation_s__
deviationist1656157___deviationist_
deviationists17104747___deviationists
dissertations1465897dissertation_s__
educationist1555267__e_ducationist_
educationists1654347__e_ducationists
elevations1338637__ele_vation_s__
enervation1369477__enervation____
estivations1449277__estivation_s__
federations1548887_feder_ation_s__
frustrations1544537frustr_ation_s__
generations12311427_gener_ation_s__
innervations1546927_innervation_s__
integrationist1583687_integrationist_
integrationists1682577_integrationists
interventionist1862907_interventionist_
isolationist1255887__is_olationist_
isolationists1384657__is_olationists
nervations1359487___nervation_s__
observation1665067_observation____
observational1853187_observation__al
observationally2371997_observationally
obstructionist18113997_obstructionist_
obstructionists19103387_obstructionists
operationism1655867__oper_ationis_m
operationisms1755097__oper_ationisms
partitionist1456267p___artitionist_
partitionists1554767p___artitionists
passivations1764437p_assivation_s__
penetrations1448857p_enetration_s__
perennations1447257p_erennation_s__
perfectionism2253987perfe__ctionis_m
perfectionisms2363297perfe__ctionisms
perfectionistic2471907perfe__ctionistic
perforations1747877perfor_ation_s__
perfusionist1753907p___erfusionist_
perfusionists1863117p___erfusionists
permeations1549887perme__ation_s__
perorations13314067p_eror_ation_s__
perpetrations1746377perpetration_s__
perpetuations1754987perpetuation_s__
persecutions1654797perse_cution_s__
perseverations1953247perseveration_s__
personations1448397pers_onation_s__
perspirations1786177perspiration_s__
perturbations17123267perturbation_s__
pervasions1545667p___ervasion_s__
precisionist1656487pr__e_cisionist_
precisionists1754637pr__e_cisionists
predations13812157pr__e_dation_s__
predications17411187pre_dication_s__
preemptions17134857pre_e_mption_s__
preferability2355257prefer_abi_li_ty
preformation1946477preformation____
prelections151210477prele__ction_s__
prelibations16127627pre_libation_s__
premeditations1955017premeditation_s__
preoperational1853247preoper_ation__al
preparation1549277prepar_ation____
preportioning1853607prepor__tioni_ng
preportions1548267prepor__tion_s__
prescription18145347prescription____
preseasons1244057prese__a_son_s__
preselection16154887preselection____
presentability2164507presentabi_li_ty
presentient1348327prese__ntien__t_
presentist12410097prese__nt___ist_
preserving1637367preserv__i_n___g
pressurizations2692717pressurization_s__
presumptions18153887pres_umption_s__
preterminations1954307pretermination_s__
prevarications2154747prevarication_s__
preventions1648537preve__ntion_s__
privations15310107pr___ivation_s__
procreations1647277pr_ocreation_s__
procurations1647407procur_ation_s__
prohibitionist2162427pr_ohibitionist_
prohibitionists2272077pr_ohibitionists
prorations12314467pr__or_ation_s__
proscriptions19114167proscription_s__
prosecutions1645617prose_cution_s__
prostration13410797prostr_ation____
protectionism1984947prote__ctionis_m
protectionisms2094027prote__ctionisms
protestations1555817protestation_s__
recordations1548647_recordation_s__
recreations13412257_re_creation_s__
reductionist1555997_r__eductionist_
reductionists1654657_r__eductionists
reformations1747607_reformation_s__
reinnervations1753447_reinnervation_s__
reiterations12410877_reiter_ation_s__
relegations1248977_rele_gation_s__
remediations1548277_remediation_s__
renovations1448427_re_novation_s__
reoperations14410067_reoper_ation_s__
reparations13611667_repar_ation_s__
representations17153897representation_s__
repressionist1555327_re_pressionist_
resections121513037_rese__ction_s__
resegregations1653697_resegregation_s__
reservist1246297_reserv_____ist_
reservists1343927_reserv_____ists
resignations1346887_resignation_s__
resorptions1347237_resor_ption_s__
respirations14410307_respiration_s__
restationing1354267_res__tationi_ng
restations10315847_res__tation_s__
restorations12410957_restoration_s__
restrictions1449287_restriction_s__
retardations1396517_retardation_s__
revelations14410307_reve_lation_s__
revisionist14146527_r__e_visionist_
revisionists15144807_r__e_visionists
revolutionist16106187_re_volutionist_
revolutionists17145127_re_volutionists
salvationism1763117___salvationis_m
salvationisms1873007___salvationisms
selectionist1458087___selectionist_
selectionists1556027___selectionists
seriations10316687___seriation_s__
serrations10313097___serration_s__
venerations14411317_vener_ation_s__

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 Filter178691950240.360496363.9
2DLD Change Limit950242009.31310203.4
3Display Results2002000.1561282.1
 (SQL Overall)1786912009.82918180.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.