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

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

100 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
fabricators185407(None) 
fabricator1744401fabricator_
abdicators1546262_abdicators
fabricates1746472fabricat_es
fabrications1945932fabrications
lubricators1553882lubricators
rubricators1553732rubricators
abdicator1446263_abdicator_
abrogators1345233_abrogators
fabricants1743023fabrica_nts
fabricate1646833fabricat__e
fabricated1845403fabricat_ed
fabricating1945033fabricating
fabrication1846603fabrication
fabulators1544693fab_ulators
fascinators1644703fascinators
fornicators1663733fornicators
lacrimators1553913lacrimators
lubricator1444173lubricator_
masticators1546323masticators
rubricator1454033rubricator_
abators94413094_ab___ators
abdicates1448154_abdicat_es
abdications1657654_abdications
abductors1443274_abduc_tors
ablators1069884_ab__lators
abnegators1343684_abnegators
abominators1553914_abominators
abrogator1245374_abrogator_
activators1545944_activators
advocators1663914_advocators
aerators8315614_aer__ators
affricates1844614affricat_es
agitators1046624_a_gitators
alligators1145774_alligators
allocators1246084_allocators
animators111210424_a_nimators
applicators1744254applicators
arbitrators1354214_arbitrators
arrogators1145374_arrogators
aspirators1247004_aspirators
aviators11169914_a_vi_ators
avigators13177094_a_vigators
barrators1148394ba_r_rators
barricadoes1671884barricadoes
barricados1572594barricado_s
captivators1853624captivators
caricature1474044ca_ricature
caricatures1564014ca_ricatures
castigators1445544castigators
dedicators1447744_dedicators
duplicators1644294duplicators
eradicators1445284eradicators
explicators2244714explicators
fabricant1644894fabrica__nt
fabrics1436094fabric____s
fabulator1445394fab_ulator_
facilitators1752784facilitators
factors12912134fa___c_tors
fascinator1545214fascinator_
febricities1844954febricities
fibromatous1852384fibromatous
fornicator1553734fornicator_
fumigators1643794f_umigators
imbricates1645294imbricat_es
imbrications1845684imbrications
indicators1348614_indicators
irrigators1145634_irrigators
irritators1045134_irritators
labradors1243794labr__adors
lacrimator1453724lacrimator_
laminators1247054la_minators
lubricates1446054lubricat_es
lubrications1645734lubrications
machinators1854404machinators
marcatos1249164ma_r_cato_s
masticator1446864masticator_
masticatory1854584masticatory
narrators947864na_r_rators
navigators1464824na_vigators
obligators13195444_obligators
obviators1444854_obvi_ators
pacificators2153004pacificators
palliators1245834palli_ators
radiators1049334ra_di_ators
rubricates1445894rubricat_es
rubrications1646264rubrications
rusticators1344944rusticators
salivators13135754sa_livators
sibilators1245714sib_ilators
sonicators1277064_sonicators
syndicators1753504syndicators
tabulators1245294tab_ulators
urinators947634__urinators
vaccinators1854144vaccinators
varactors1446414va_rac_tors
variegators1552714va_riegators
varistors1246534va_ri_stors
vibrators14237254vibr__ators
vindicators1744534vindicators

Search took 10 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.436409841.7
2DLD Change Limit1488191009.31015984.9
3Display Results1001000.0462173.9
 (SQL Overall)1786911009.79218248.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.