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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
prefabricating246173(None) 
prefabrication2392822prefabrication
prefabrications2492432prefabrications
prevaricating2153072preva_ricating
fabricating1945033___fabricating
prefabricate2191873prefabricat__e
prefabricated2391703prefabricat_ed
prefabricates2291843prefabricat_es
relubricating1863093_relubricating
defibrinating2052464_defibrinating
predicating1749654pre___dicating
prevarication2055244preva_rication
prevarications2154744preva_rications
repatriating1545454_repatri_ating
rubricating1645104_r__ubricating
abdicating1686155____abdicating
affricating2043965__af_fricating
defalcating1844345_defa__lcating
defibrillating21111605_defibrillating
demarcating1745205_dema_r_cating
divaricating1953595_diva_ricating
embrocating1844135__e_mbrocating
eradicating1556625__era_dicating
extricating2146685__e_xtricating
fabrication1846605___fabrication
fabrications1945925___fabrications
imbricating1844515___imbricating
inebriating1446055ine__bri_ating
lubricating1644715___lubricating
metricating1647355_me__tricating
patriating13510205p___atri_ating
peregrinating1752975p_eregrinating
perforating1747025perf_or__ating
preacting142412535pre_a___c_ting
preadmitting1852765pre_admi_tting
precipitating2074035pre_cipitating
predestinating1854275predestinating
predicting1649875pre___dic_ting
predominating1964345pre_dominating
preerecting1646145pre__erec_ting
prefabbing2042585prefab____bing
prefacing17118745prefa___c__ing
preflighting2252655pref__lighting
preformatting2152075pref_ormatting
preformulating2281875preformulating
prelocating1647415pre___locating
premarketing2152565prema_r_keting
premeditating1953655pre_meditating
prenominating1854695pre_nominating
prepricing1746735pre__pric__ing
preprinting1647415pre__pri_nting
prepublication2252925prepublication
prepublications2372665prepublications
pretreating1448895pre__tr_eating
prevaricate1863425preva_ricat__e
prevaricated20112865preva_ricat_ed
prevaricates1963235preva_ricat_es
prevaricator1962405preva_ricat_or
prevaricators2062205preva_ricators
prewriting1647245pre__wri__ting
radicating1459065_r__a_dicating
reactivating1844755_re_activating
readdicting1643815_re_addic_ting
reallocating1573665_re_allocating
reanimating1447235_re_a_nimating
reciprocating2052855_reciprocating
rededicating1744335_re_dedicating
reduplicating1953505_reduplicating
refracting1638735_ref__rac_ting
rehabilitating2061855_rehabilitating
relubrication1754505_relubrication
relubrications1854195_relubrications
replicating1649095_re__plicating
reradiating1347265_rera_di_ating
restricting1449305_re_stric_ting
retaliating1248875_reta_li_ating
revaccinating2152705_revaccinating
revalidating1744185_reva_lidating
revibrating1745575_revibr__ating
syllabicating2161505syllab_icating
trifurcating1852145trif_ur_cating

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 Filter178691950240.1101624463.6
2DLD Change Limit95024816.54614516.3
3Display Results81810.0601350.0
 (SQL Overall)178691816.71626606.8
 
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.