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

103 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
prefabrications2492431prefabrications_
prefabrication2392822prefabrication__
prefabricating2461733prefabricati_n_g
prevarications2154743preva_rications_
fabrications1945924___fabrications_
prefabricates2291844prefabricat__es_
prepublications2372664prepublications_
prevarication2055244preva_rication__
relubrications1854194_relubrications_
defibrinations2053415_defibrinations_
fabrication1846605___fabrication__
predications17411185pre___dications_
prefabricate2191875prefabricat____e
prefabricated2391705prefabricat___ed
preformations2045715pref_or_mations_
preparations1648315prepa_r__ations_
prepublication2252925prepublication__
pressurizations2692715pressurizations_
prettifications22135185prettifications_
prevaricating2153075preva_ricati_n_g
prevaricators2062205preva_ricat_ors_
relubrication1754505_relubrication__
repatriations15136515_repatri_ations_
republications2074455_republications_
rubrications1646265_r__ubrications_
abdications1657656____abdications_
defalcations1845196_defa__lcations_
defibrillations2161696_defibrillations_
defibrination1953866_defibrination__
demarcations1746126_dema_r_cations_
divarications1955506_diva_rications_
embrocations1843986__e_mbrocations_
eradications1549306__era_dications_
extrications2149056__e_xtrications_
fabricating1945036___fabricati_n_g
fabricators1854076___fabricat_ors_
imbrications1845686___imbrications_
inebriations1456326ine__bri_ations_
lubrications1645736___lubrications_
metrications1649836_me__trications_
penalizations24511636p_ena_lizations_
peregrinations17114686p_eregrinations_
perforations1747876perf_or__ations_
petrifications2148026p_etrifications_
polarizations24219716p_ola_rizations_
preadaptations1951756pre_adaptations_
precipitations2085396pre_cipitations_
preconvictions2353356preconvic_tions_
predestinations1865006predestinations_
predication16412436pre___dication__
predictions1649656pre___dic_tions_
predominations19105546pre_dominations_
prefigurations2053026pref_igurations_
preformation1946476pref_or_mation__
preformationist2272226pref_or_mationist
prelibations16127626pre___libations_
premeditations1955016pre_meditations_
prenominations18105766pre_nominations_
preordinations1765716pre_ordinations_
preparation1549276prepa_r__ation__
prescriptions19135336pre_scri_ptions_
preservations1895546pre_ser_vations_
pressurization2593126pressurization__
preterminations1954306preterminations_
prettification21115716prettification__
preunification2154306preunification__
prevaricates1963236preva_ricat__es_
prevaricator1962406preva_ricat_o__r
privatizations2855176priva_tizations_
profanations17175256profa___nations_
publications1845836p___ublications_
purifications2047466purif___ications_
reactivations18176146_re_activations_
reaffirmations2251976_reaffirmations_
realizations21415536_re_a_lizations_
reallocations1553806_re_allocations_
reanimations1468786_re_a_nimations_
reapplications2054256_reapplications_
reciprocations20203386_reciprocations_
rectifications2148916_rectifications_
rededications1746126_re_dedications_
reduplications1964536_reduplications_
reformations1747606_ref_or_mations_
refractions16127726_ref__rac_tions_
rehabilitations2053036_rehabilitations_
reifications17411826_re__ifications_
relubricating1863096_relubricati_n_g
reparations13611666_repa_r__ations_
repatriation14126976_repatri_ation__
replications16811056_re__plications_
republication1964636_republication__
reradiations1349496_rera_di_ations_
restrictions1449286_re_stric_tions_
retaliations12511406_reta_li_ations_
retardations1396516_reta_r_dations_
reunifications19136916_reunifications_
revaccinations2153616_revaccinations_
revalidations1747116_reva_lidations_
revalorizations2754556_revalorizations_
rubrication1547126_r__ubrication__
syllabications2152026syllab_ications_
trifurcations1852866trif_ur_cations_
velarizations2549276_vela_rizations_

Search took 7 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 Filter178691658740.390458182.1
2DLD Change Limit658741036.42310256.0
3Display Results1031030.0931107.5
 (SQL Overall)1786911036.90625874.7
 
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.