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

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

116 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
preformations204571(None) 
preformation1946471preformation_
reformations1747601_reformations
deformations1846842_deformations
perforations1747872perfor_ations
preformationist2272222preformationist
reformation1648412_reformation_
conformations2046723conformations
deformation1747663_deformation_
formations1538203___formations
informations17127033_informations
malformations2053073malformations
perforation1649003perfor_ation_
performatives2392683performatives
perorations13314063p_eror_ations
preformats1744413preformat___s
preformatting2152073preformatting
preparations1648313prepar_ations
preportions1548263prepor__tions
preservations1895543preservations
prorations12314463pr__or_ations
recordations1548643_recordations
reformational18113423_reformational
reformulations1953553_reformulations
affirmations2053234_affirmations
confirmations2055674confirmations
conformation1947324conformation_
cremations14410714cre___mations
decorations14312884_decor_ations
defamations1745894_def_amations
deflorations1646064_deflor_ations
defoliations1647594_defoliations
deformational19122974_deformational
deportations1548464_deportations
formation1439424___formation_
information16147714_information_
malformation1953324malformation_
percolations1648054perco_lations
perforating1747024perfor_ati_ng
perforators1644854perfor_at_ors
performative22103874performati_ve
performatory2252584performat_ory
permeations1549884p_e__rmeations
peroration12316004p_eror_ation_
personations1448394perso_nations
perturbations17123264perturbations
precognitions1853594precognitions
preconditions1854894preconditions
predations13812154pre___dations
predications17411184pre_dications
predominations19105544predominations
preemptions17134854pre__emptions
prefabrications2492434prefabrications
prefigurations2053024prefigurations
preformat1646364preformat____
preformatted2052274preformat_ted
preforming1846234preform__i_ng
preformulating2281874preformulati_ng
prelibations16127624pre_libations
premonitions1646854premo_nitions
prenominations18105764prenominations
prenotions1248294preno___tions
preoptions1447644pre_o__ptions
preordains13124524pre_orda_i_ns
preordinations1765714pre_ordinations
preparation1549274prepar_ation_
preportion1448874prepor__tion_
prepositions16108304prepo_sitions
prescriptions19135334prescriptions
presentations1548134presentations
preservation1776284preservation_
presumptions18153884pre_sumptions
preterminations1954304preterminations
prevarications2154744prevarications
probations14311084pr__o_bations
proclamations1952694proclamations
procreations1647274pr_ocreations
procurations1647404procur_ations
profanations17175254prof_anations
prolongations1673354prolongations
promotions1448784pr__o_motions
pronations12314034pr__o_nations
proportions1548464propor__tions
proration11415984pr__or_ation_
prorogations1556724pr__orogations
prostrations1449764prostr_ations
protonations1449074proto_nations
provocations1956874provo_cations
reaffirmations2251974_reaffirmations
reanimations1468784_reanimations
reclamations1645714_reclamations
recordation1449264_recordation_
recreations13412254_re_creations
reflations13311234_ref__lations
reforestations1754464_reforestations
reformates1546264_reformat__es
reformative1945674_reformati_ve
reformatory19123444_reformat_ory
reformats1445714_reformat___s
reformatting1852704_reformatting
reformulation1853974_reformulation_
refoundations17102634_refoundations
refractions16127724_ref_ractions
refutations1448674_ref_utations
relocations13311144_relo_cations
renovations1448424_reno_vations
reparations13611664_repar_ations
reprobations1647774_reprobations
reservations1588584_reservations
resorptions1347234_resor_ptions
restorations12410954_restor_ations
retardations1396514_retardations
retortions1049144_retor__tions
revocations16410314_revo_cations
transformations2062824transformations
trifurcations1852864trifurcations

Search took 6 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 Limit950241165.47017371.8
3Display Results1161160.0631841.3
 (SQL Overall)1786911165.89330322.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.