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

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

108 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
exterminators225296(None) 
exterminator2153251exterminator_
exterminatory2562481exterminatory
determinators1653892determinators
exterminates2154292exterminat_es
exterminations2365122exterminations
terminators1346022__terminators
determinator1554573determinator_
exterminate2054543exterminat__e
exterminated2253603exterminat_ed
exterminating2373853exterminating
extermination2275743extermination
terminator1246633__terminator_
alternators1154104alter__nators
determinations1766884determinations
eliminators1344814e__liminators
extenuators1852994exte__nuators
exteriors1647324exter_i___ors
extermines1947784extermin___es
exteroceptors2461824exteroceptors
extirpators2053164extir__pators
inseminators1453764inse_minators
terminates1249994__terminat_es
terminations14149754__terminations
abominators1553915__abominators
alternator1044555alter__nator_
chlorinators1753185chlor_inators
contaminators1754885contaminators
coordinators1553805_coordinators
coterminous1552545cotermin__ous
denominators1574095_denominators
determinacies1853195determinacies
determinants1553475determina_nts
determinate1446625determinat__e
determinately1953195determinately
determination1657645determination
determinative1954075determinative
determinatives2052935determinatives
determiners1444645determin__ers
discriminators1962815discriminators
disseminators1653065disseminators
dominators1397485___dominators
effeminates1952605effe_minat_es
eliminator1245125e__liminator_
elutriators1153045elutr_i_ators
emanators1147035___e_manators
enervators1345705e_ner__vators
estimators1247015est___imators
estivators1345915est___ivators
eternizations2258065e_ternizations
examinations2167465ex__aminations
excerptors2163465excer___ptors
execrators1946025ex_e__crators
exercitations2254555ex_ercitations
expeditors2043645expe_di__tors
experimenters2472445experimenters
expiators1846805ex___pi_ators
explicators2244715ex__plicators
expurgators2152565expur__gators
extensors1644085exte___n_sors
extenuator1753225exte__nuator_
extenuatory2152465exte__nuatory
exterior1547375exter_i___or_
extermine1848285extermin____e
extermined2045325extermin___ed
extermining2154045extermin__ing
externals1666625exter__na__ls
exteroceptor2361855exteroceptor_
extirpator1953275extir__pator_
extractors1946425ext_r__actors
extrapolators2262415extrapolators
extremists1984535extremi_st__s
extremities2053805extremi__ties
extricates1998235ext_r_icat_es
extrications2149045ext_r_ications
fermentors1594235__fermen_tors
germinates1347755__germinat_es
germinations15137945__germinations
hibernators1652865hiber__nators
illuminators1453275_illuminators
impersonators1792495impersonators
inseminator1354245inse_minator_
interdictors1554455interdi_ctors
intermitters1454605intermi_tters
interpolators1554855interpolators
interrogators1454285interrogators
intimidators1554165int_imidators
laminators1247045___laminators
literators1048105liter___ators
nominators1277555___nominators
permeators1447405__perm_eators
personators1345545__personators
potentiators1453215potenti_ators
preterminations1954295preterminations
ratiocinators1562155ratiocinators
ruminators1286065___ruminators
sternutators1251495_sternutators
subordinators1662325subordinators
terminals1147455__termina__ls
terminate11411205__terminat__e
terminated1348165__terminat_ed
terminating1447335__terminating
termination131311165__termination
terminative1656135__terminative
thermistors1653095_thermi_stors
tormentors1244165__tormen_tors
urinators947625___ur_inators
vaticinators1763375vat_icinators

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901089.42013247.3
3Display Results1081080.0801350.0
 (SQL Overall)1786911089.64018536.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.