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

210 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
fabrication184660(None) 
fabrications1945931fabrications
abdication1548222_abdication
fabricating1945032fabricating
fabricator1744402fabricat_or
imbrication1746462imbrication
lubrication1546342lubrication
rubrication1547122rubrication
abdications1657653_abdications
abreaction1444653_abreaction
abrogation13107333_abrogation
embrocation1744583embrocation
extrication2049793extrication
fabricate1646833fabricat__e
fabricated1845403fabricat_ed
fabricates1746473fabricat_es
fabricators1854073fabricators
fasciation1546833fasci_ation
fascination1646793fascination
fiberization26136713fiberization
fibrillation1753533fibrillation
fimbriation1843553fimbri_ation
floriation1367793flori_ation
fornication1645953fornication
friction1347913f__ric_tion
furcation1448353f_ur_cation
habitation1547913hab_itation
imbrications1845683imbrications
lacrimation1546263lacrimation
lubrications1645733lubrications
marination12312813ma_rination
mastication15610293mastication
metrication15410653metrication
prefabrication2392823prefabrication
publication1746573publication
rubrications1646263rubrications
variation12312393va_ri_ation
abdicating1686154_abdicating
abdicator1446264_abdicat_or
abduction14125414_abduc_tion
aberration1267204_aberration
abjection2045324_abjec_tion
abjuration1945884_abjuration
ablation10312434_ab__lation
abnegation1345414_abnegation
abomination1547484_abomination
abrasion1046624_abr__asion
abreactions1544194_abreactions
abrogations14116464_abrogations
abruption1343974_abr_uption
activation15610134_activation
addiction13146014_addic_tion
admiration1347734_admiration
advocation1645744_advocation
aeration8319934_aer__ation
affirmation1953684affirmation
affixation2344394_affixation
affliction1843544afflic_tion
affricating2043964affricating
affricative2253034affricative
agitation10311224_a_gitation
allocation1248574_allocation
animation11313684_a_nimation
application1747474application
arbitration1346474_arbitration
arborization2347884arborization
arcuation11410584_a_rcuation
arrogation11107444_arrogation
aspiration1249994_aspiration
aviation11312744_a_vi_ation
avocation14168994_a_vocation
barbarization26186084barbarization
basification19127324basification
calcination1548904calcination
capitation14311364ca_pitation
caprification2256054caprification
captivation1846174captivation
carbonation1545854carbonation
carburization2654584carburization
carnation11312944ca_r_nation
castigation1447974castigation
cavitation1549134ca_vitation
claudication1753324claudication
darnation1039824da_r_nation
dedication14311964_dedication
defibrination1953864defibrination
deification17411664deification
deprecation1648964deprecation
deprivation1788774deprivation
derivation14712784_derivation
divarication1855904divarication
dubitation1377334dub_itation
duplication1647294duplication
edification1749354edification
embrocations1843984embrocations
eradication14410114eradication
explication2248454explication
extrications2149054extrications
fabricant1644894fabrica__nt
fabricants1743024fabrica_nts
facilitation1746574facilitation
faction122613334fa___c_tion
factorization2756284factorization
falsification2145244falsification
fasciations1646264fasci_ations
fasciculation20133564fasciculation
fascinations1746374fascinations
febricities1844954febricities
fiberizations27136374fiberizations
fibrillations1853114fibrillations
fiction122010734f___ic_tion
filiation121110244f_ili_ation
fimbriations1943354fimbri_ations
fixation1837074f___ixation
flirtation1354824flir_tation
floriations1476914flori_ations
fluoridation1673634fluoridation
fluorination1594714fluorination
foliation121110794f_oli_ation
formation1439424f_or_mation
fornications1755404fornications
fraction1359484f__rac_tion
fricative1746744f__ricative
frictions1448034f__ric_tions
fulmination1655884fulmination
fumigation1645624f_umigation
furcations1547534f_ur_cations
fustigation1545214fustigation
gasification1867104gasification
habilitation1795514habilitation
habitations1646884hab_itations
habituation1643594habituation
hebraization26126144hebraization
imbricating1844524imbricating
implication1747774implication
imprecation1746544imprecation
indication13312034_indication
inebriation1357244inebri_ation
irrigation1147804_irrigation
irritation1048974_irritation
jactitation2045624jactitation
jubilation1946054jub_ilation
lacrimations1645704lacrimations
laicization2247904laicization
lamination12311224la_mination
laterization21410684laterization
laureation1046154laur_eation
libration111510164libr__ation
lubricating1644714lubricating
lubricative1853454lubricative
lubricator1444174lubricat_or
machination18106824machination
margination1447434margination
marinations13411274ma_rinations
mastications1649414mastications
matriculation17125384matriculation
medication15411174_medication
metrications1649834metrications
narration9310064na_r_ration
navigation1446004na_vigation
nazification2646044nazification
obligation1346784_obligation
obviation1446094_obvi_ation
pacification2168054pacification
pagination1348994pa_gination
palliation1248504palli_ation
palpitation1546244palpitation
passivation16104744passivation
patination12312574pa_tination
plication13311684__plication
predication16412434predication
prefabrications2492434prefabrications
privation14311174__privation
publications1845834publications
radiation10313404ra_di_ation
ramification1998214ramification
ratification17810664ratification
reification16412904reification
relubrication1754504relubrication
replication15712014replication
rubricating1645104rubricating
rubricator1454034rubricat_or
rustication1349224rustication
salivation1349814sa_livation
sanitation10412044sa_nitation
satiation9313434sa_ti_ation
seriation9318064_seri_ation
sibilation12128774sib_ilation
sonication12411184_sonication
striation9313484_stri_ation
striction1148984_stric_tion
suberization2359244suberization
sublimation1557184sublimation
subrogation1446004subrogation
syndication17124964syndication
tabulation1247814tab_ulation
tarnation9310094ta_r_nation
umbilication1884744umbilication
unification1648734unification
urination9312174__urination
urtication1249114_urtication
vacation131911894va___cation
vaccination1846464vaccination
validation1448414va_lidation
valorization2478414valorization
vaporization2697534vaporization
variations13310774va_ri_ations
variegation1543454va_riegation
vibration14138204vibr__ation
vindication1746354vindication

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 Filter1786911488190.423422437.4
2DLD Change Limit1488192108.32617874.0
3Display Results2102100.1101909.1
 (SQL Overall)1786912108.85920170.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.