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

97 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
cantatrices155344(None) 
cantatrice1463461cantatrice_
cantatrici1452702cantatric_i
aviatrices1543163_aviatrices
canaries10318943can_a_ri_es
cantabiles1445763canta_biles
cantharides1754033cantharides
centauries1245533centauri_es
cicatrices1343493c_icatrices
cockatrices1852333cockatrices
testatrices1352803testatrices
angaries9314394_anga_ri_es
antalgics1245174_antalgic_s
anthelices1546434_anthelices
anthraces1448894_ant_hraces
antitrades1146524_antitrades
astatines9310344_astat_ines
atabrines1144464_a_tabrines
attrites8311564_a_t_trites
avarices1337184_a_va_rices
aviatrice1443074_aviatrice_
aviatrixes2042094_aviatrixes
banditries1345344banditri_es
barratries1245734barratri_es
calmatives1744734calmat_ives
calvaries1449804calva_ri_es
canalises11515494can_a_lises
canalizes201113784can_a_lizes
canities101519264can_it_i_es
cannabises1444434canna_bises
canneries11313084can_neri_es
cannonries1244094cannonri_es
canonries1148414can_onri_es
cantabile1346894canta_bile_
cantaloupes15182554cantaloupes
cantatas103410094cantat___as
cantharis1447184canthari__s
canthitises1643554canthitises
canticles1339184can__t_icles
cantrips12318934can__tri_ps
caprices1439894c___aprices
captaincies1752654captaincies
carices114220954c___a_rices
caryatides1644494caryat_ides
catamites1349364ca_ta_mites
cataracts1345584ca_ta_racts
catarrhines1652244ca_tarrhines
catatonics1444604ca_tatonic_s
cathartics1743084cathartic_s
catteries11815524ca_tteri_es
catties94023054ca_t_t_i_es
causatives1543634causat_ives
cauteries11615394caut_eri_es
cauterizes2197994caut_erizes
cavalries1446364ca_valri_es
centares102913894centa_r__es
centauric1343604centauric__
centuries11311334cent_uri_es
chantries14310294chan__tri_es
cicatrice1243414c_icatrice_
cicatrixes2142584c_icatrixes
cicatrizes2343844c_icatrizes
coadjutrices246574coadjutrices
cockatrice1752394cockatrice_
constatives1646934constat_ives
constricts1477734con_stricts
contraries12711934contrari_es
contrives14311704con__trives
dataries9314034da_ta_ri_es
dentifrices1751864dentifrices
fanatics1367184fan_at_ic_s
fantasies1298854fanta_si_es
fantasises1395884fanta_sises
fantasizes2295464fanta_sizes
fantasticoes1752084fantasticoes
fantastics1544374fantastic_s
fellatrices1652504fellatrices
gantries91413794gan__tri_es
generatrices1552254generatrices
gentrices1258914gen__trices
gyniatries1442974gyniatri_es
laniaries9411224lania_ri_es
lattices1038384la_t_t_ices
mandataries1453824mandatari_es
mandatories1454974mandatori_es
matrices12312084___matrices
mediatrices1653384mediatrices
oratrices1145834__oratrices
pantries101817394pan__tri_es
sanitaries1049914sanita_ri_es
statices102712344__stat_ices
tanistries1047064tanistri_es
tantalises101010104tanta_lises
tantalites1099284tanta_lites
tantalizes19109944tanta_lizes
tentatives1345484tentat_ives
testatrixes1852094testatrixes

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.423422437.4
2DLD Change Limit148819979.20316170.7
3Display Results97970.0631539.7
 (SQL Overall)178691979.68918442.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.