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) 
preformations2045692preformation_s_
preformation1946473preformation___
preservationist2062803preservationist
reformations1747593_reformation_s_
deformations1846834_deformation_s_
perforations1747844perfor_ation_s_
recreationist1555734_re_creationist
reformation1648414_reformation___
reformational18113424_reformation_al
reservationist17114324_reservationist
conformations2046715conformation_s_
creationist1379225cre____ationist
deformation1747665_deformation___
deformational19122975_deformation_al
formations1538195___formation_s_
informations17127035_information_s_
malformations2053075malformation_s_
operationist1457915ope__r_ationist
perfectionist2055325perf__ectionist
perforation1648995perfor_ation___
performatives2392685performati_ves_
perorations13314035p_eror_ation_s_
preformats1744415preformat____s_
preformatting2152075preformat__ting
preparations1648305prepar_ation_s_
preportioning1853605prepor__tioning
preportions1548245prepor__tion_s_
preservations1895545preservation_s_
projectionist2485235pr__ojectionist
prorations12314435pr__or_ation_s_
protectionist17116655pr__otectionist
recordations1548625_recordation_s_
recreationists1664365_re_creationists
reformatories1862555_reformat_ories
reformulations1953555_reformulation_s_
repudiationist17183185_repudiationist
reservationists1873695_reservationists
restrictionist1665035_restrictionist
revolutionist16106175_revo_lutionist
separationist1555265_separ_ationist
abortionist1356156__abor__tionist
affirmations2053236_affirmation_s_
associationist16173356_associationist
confirmations2055676confirmation_s_
conformation1947326conformation___
conformational21153706conformation_al
conservationist2084016conservationist
contortionist15104406contor__tionist
cooperationist1864206cooper_ationist
creationism1576456cre____ationism
creationists1476596cre____ationists
cremations14410706cre___mation_s_
decorations14312856_decor_ation_s_
defamations1745896_def_amation_s_
deflorations1646056_deflor_ation_s_
defoliations1647596_defoliation_s_
demolitionist1654506_demo_litionist
deportations1548456_deportation_s_
destructionist17104946_destructionist
deviationist1656146_de__viationist
devolutionist17135146_devo_lutionist
educationist1555256__e_ducationist
elocutionist1455086__elo_cutionist
evolutionist15126806__evo_lutionist
extortionist1975306_extor__tionist
formation1439426___formation___
inflationist1555286_inf__lationist
information16147716_information___
informational1854336_information_al
integrationist1583686integr_ationist
isolationist1255876__iso_lationist
liberationist15124716_liber_ationist
malformation1953326malformation___
operationism1655836ope__r_ationism
operationists1556036ope__r_ationists
partitionist1456246p___artitionist
percolations1648026perco_lation_s_
perfectionism2253976perf__ectionism
perfectionists2164006perf__ectionists
perforating1747016perfor_ati_n__g
perforators1644856perfor_at_o_rs_
performability2663006performabi_lity
performative22103876performat___ive
performatory2252586performat_o__ry
perfusionist1753896p_e__rfusionist
permeations1549866p_e__rmeation_s_
peroration12315996p_eror_ation___
perorational1446386p_eror_ation_al
personations1448386perso_nation_s_
perturbations17123256perturbation_s_
pragmaticist1973556pr__agmati_cist
precisionist1656476pre___cisionist
precognitions1853596precognition_s_
preconditioning2161806preconditioning
preconditions1854886precondition_s_
predations13812146pre___dation_s_
predications17411176pre_dication_s_
predominations19105546predomination_s_
preemptions17134836pre__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_
prenotions1248286preno___tion_s_
preoptions1447616pre_o__ption_s_
preordaining1652516pre_orda_i_ning
preordains13124526pre_orda_i_n_s_
preordinations1765706pre_ordination_s_
preparation1549276prepar_ation___
preportion1448876prepor__tion___
preportioned1754256prepor__tion_ed
prepositions16108286prepo_sition_s_
prerevisionist19102526pre_revisionist
prescriptions19135326prescription_s_
presentations1548136presentation_s_
preservation1776286preservation___
presumptions18153876pre_sumption_s_
preterminations1954296pretermination_s_
prevarications2154736prevarication_s_
prevocational2054016prevo_cation_al
probations14311066pr__o_bation_s_
proclamations1952696proclamation_s_
procreations1647256pr_ocreation_s_
procurations1647386procur_ation_s_
profanations17175256prof_anation_s_
prohibitionist2162416pr_ohibitionist
projectionists2594106pr__ojectionists
prolongations1673336prolongation_s_
promotions1448766pr__o_motion_s_
pronations12314036pr__o_nation_s_
proportioning1863956propor__tioning
proportions1548446propor__tion_s_
proration11415986pr__or_ation___
prorogations1556706pr__orogation_s_
prostrations1449746prostr_ation_s_
protagonist1455206pr__o_ta_gonist
protectionism1984916pr__otectionism
protectionists18105126pr__otectionists
protonations1449046proto_nation_s_
provocations1956846provo_cation_s_
reaffirmations2251976_reaffirmation_s_
reanimations1468786_reanimation_s_
receptionist1656376_re__ceptionist
reclamations1645716_reclamation_s_
recordation1449256_recordation___
recreations13412236_re_creation_s_
reductionist1555986_re__ductionist
reflations13311236_ref__lation_s_
reforestations1754456_reforestation_s_
reformability2354626_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_
relocations13311136_relo_cation_s_
renovations1448416_reno_vation_s_
reparations13611656_repar_ation_s_
repressionist1555306_re_pressionist
reprobations1647776_reprobation_s_
repudiationists18212636_repudiationists
reservations1588586_reservation_s_
resorptions1347216_resor_ption_s_
restorations12410936_restor_ation_s_
restrictionism1863786_restrictionism
restrictionists1764086_restrictionists
resurrectionist1762826_resurrectionist
retardations1396516_retardation_s_
retortions1049126_retor__tion_s_
revocations16410306_revo_cation_s_
revolutionise16134486_revo_lutionise
revolutionists17145126_revo_lutionists
segregationist1692906_segregationist
separationists1664086_separ_ationists
transformations2062826transformation_s_
trifurcations1852866trifurcation_s_

Search took 9 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.1231452772.4
2DLD Change Limit950241877.94011967.8
3Display Results1871870.1401335.7
 (SQL Overall)1786911878.20321783.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.