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

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

187 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
preformationist227222(None) 
preformations2045712preformation_s_
preformation1946473preformation___
preservationist2062803preservationist
reformations1747603_reformation_s_
deformations1846844_deformation_s_
perforations1747874perfor_ation_s_
recreationist1555744_re_creationist
reformation1648414_reformation___
reformational18113424_reformation_al
reservationist17114334_reservationist
conformations2046725conformation_s_
creationist1379235cre____ationist
deformation1747665_deformation___
deformational19122975_deformation_al
formations1538205___formation_s_
informations17127035_information_s_
malformations2053075malformation_s_
operationist1457945ope__r_ationist
perfectionist2055335perf__ectionist
perforation1649005perfor_ation___
performatives2392685performati_ves_
perorations13314065p_eror_ation_s_
preformats1744415preformat____s_
preformatting2152075preformat__ting
preparations1648315prepar_ation_s_
preportioning1853605prepor__tioning
preportions1548265prepor__tion_s_
preservations1895545preservation_s_
projectionist2485255pr__ojectionist
prorations12314465pr__or_ation_s_
protectionist17116685pr__otectionist
recordations1548645_recordation_s_
recreationists1664375_re_creationists
reformatories1862555_reformat_ories
reformulations1953555_reformulation_s_
repudiationist17183185_repudiationist
reservationists1873695_reservationists
restrictionist1665045_restrictionist
revolutionist16106185_revo_lutionist
separationist1555275_separ_ationist
abortionist1356166__abor__tionist
affirmations2053236_affirmation_s_
associationist16173356_associationist
confirmations2055676confirmation_s_
conformation1947326conformation___
conformational21153716conformation_al
conservationist2084026conservationist
contortionist15104426contor__tionist
cooperationist1864226cooper_ationist
creationism1576466cre____ationism
creationists1476626cre____ationists
cremations14410716cre___mation_s_
decorations14312886_decor_ation_s_
defamations1745896_def_amation_s_
deflorations1646066_deflor_ation_s_
defoliations1647596_defoliation_s_
demolitionist1654516_demo_litionist
deportations1548466_deportation_s_
destructionist17104966_destructionist
deviationist1656156_de__viationist
devolutionist17135156_devo_lutionist
educationist1555266__e_ducationist
elocutionist1455096__elo_cutionist
evolutionist15126816__evo_lutionist
extortionist1975316_extor__tionist
formation1439426___formation___
inflationist1555296_inf__lationist
information16147716_information___
informational1854346_information_al
integrationist1583686integr_ationist
isolationist1255886__iso_lationist
liberationist15124736_liber_ationist
malformation1953326malformation___
operationism1655866ope__r_ationism
operationists1556056ope__r_ationists
partitionist1456266p___artitionist
percolations1648056perco_lation_s_
perfectionism2253986perf__ectionism
perfectionists2164016perf__ectionists
perforating1747026perfor_ati_n__g
perforators1644856perfor_at_o_rs_
performability2663036performabi_lity
performative22103876performat___ive
performatory2252586performat_o__ry
perfusionist1753906p_e__rfusionist
permeations1549886p_e__rmeation_s_
peroration12316006p_eror_ation___
perorational1446396p_eror_ation_al
personations1448396perso_nation_s_
perturbations17123266perturbation_s_
pragmaticist1973566pr__agmati_cist
precisionist1656486pre___cisionist
precognitions1853596precognition_s_
preconditioning2161806preconditioning
preconditions1854896precondition_s_
predations13812156pre___dation_s_
predications17411186pre_dication_s_
predominations19105546predomination_s_
preemptions17134856pre__emption_s_
prefabrications2492436prefabrication_s_
prefigurations2053026prefiguration_s_
preformat1646366preforma______t
preformatted2052276preformat___ted
preforming1846236preform__i_n__g
preformulating2281876preformulati_n__g
prelibations16127626pre_libation_s_
premonitions1646856premo_nition_s_
prenominations18105766prenomination_s_
prenotions1248296preno___tion_s_
preoptions1447646pre_o__ption_s_
preordaining1652516pre_orda_i_ning
preordains13124526pre_orda_i_n_s_
preordinations1765716pre_ordination_s_
preparation1549276prepar_ation___
preportion1448876prepor__tion___
preportioned1754256prepor__tion_ed
prepositions16108306prepo_sition_s_
prerevisionist19102526pre_revisionist
prescriptions19135336prescription_s_
presentations1548136presentation_s_
preservation1776286preservation___
presumptions18153886pre_sumption_s_
preterminations1954306pretermination_s_
prevarications2154746prevarication_s_
prevocational2054016prevo_cation_al
probations14311086pr__o_bation_s_
proclamations1952696proclamation_s_
procreations1647276pr_ocreation_s_
procurations1647406procur_ation_s_
profanations17175256prof_anation_s_
prohibitionist2162426pr_ohibitionist
projectionists2594116pr__ojectionists
prolongations1673356prolongation_s_
promotions1448786pr__o_motion_s_
pronations12314036pr__o_nation_s_
proportioning1863956propor__tioning
proportions1548466propor__tion_s_
proration11415986pr__or_ation___
prorogations1556726pr__orogation_s_
prostrations1449766prostr_ation_s_
protagonist1455206pr__o_ta_gonist
protectionism1984946pr__otectionism
protectionists18105146pr__otectionists
protonations1449076proto_nation_s_
provocations1956876provo_cation_s_
reaffirmations2251976_reaffirmation_s_
reanimations1468786_reanimation_s_
receptionist1656406_re__ceptionist
reclamations1645716_reclamation_s_
recordation1449266_recordation___
recreations13412256_re_creation_s_
reductionist1555996_re__ductionist
reflations13311236_ref__lation_s_
reforestations1754466_reforestation_s_
reformability2354646_reformabi_lity
reformates1546266_reformat___es_
reformative1945676_reformat___ive
reformatory19123446_reformat_o__ry
reformats1445716_reformat____s_
reformatting1852706_reformat__ting
reformist1445916_reform_____ist
reformulation1853976_reformulation___
refoundations17102636_refoundation_s_
refractions16127726_ref_raction_s_
refutations1448676_ref_utation_s_
relocations13311146_relo_cation_s_
renovations1448426_reno_vation_s_
reparations13611666_repar_ation_s_
repressionist1555326_re_pressionist
reprobations1647776_reprobation_s_
repudiationists18212636_repudiationists
reservations1588586_reservation_s_
resorptions1347236_resor_ption_s_
restorations12410956_restor_ation_s_
restrictionism1863786_restrictionism
restrictionists1764086_restrictionists
resurrectionist1762836_resurrectionist
retardations1396516_retardation_s_
retortions1049146_retor__tion_s_
revocations16410316_revo_cation_s_
revolutionise16134486_revo_lutionise
revolutionists17145126_revo_lutionists
segregationist1692916_segregationist
separationists1664086_separ_ationists
transformations2062826transformation_s_
trifurcations1852866trifurcation_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.356501941.0
2DLD Change Limit950241878.75310856.2
3Display Results1871870.1231520.3
 (SQL Overall)1786911879.23219355.6
 
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.