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

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

140 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
cantrips1231893(None) 
cantraips13255271cantraips
cantraps12319111cantraps
cantrip112910041cantrip_
caltraps12327252caltraps
caltrops12307862caltrops
canaries10318942canaries
cantraip12326392cantraip_
cantrap113310282cantrap_
catnips1195892ca_tnips
chantries14310292chantries
gantries91413782gantries
mantraps12298062mantraps
pantries101817392pantries
antics84621453_ant_ics
antis55033313_ant_i_s
antres65021003_antr_es
antrums969173_antrums
anurias7312253_anurias
atrip75315753_a_trip_
attrits7310613_attrits
banties94324763bant_ies
calorics122810463calorics
calories102919553calories
calthrops1654053calthrops
caltrap11297943caltrap_
caltrop11267643caltrop_
cambrics1645253cambrics
canakins142010463canakins
canards10311203canar_ds
cancroids1444533cancroids
candids113812693can_dids
candies104125613can_dies
caners84629203caner__s
canids95118133can__ids
canikins14219163canikins
canities101519263canities
canneries11313083canneries
canonries1148413canonries
canopies12311853canopies
canorous10310193canorous
cantalas104013523cantalas
cantals93919573cant_als
cantatas103410093cantatas
cantdogs1244043cantdogs
canteens1038573canteens
cantering122417373cantering
canters94827733cant_ers
cantharis1447183canthari_s
canthi11310973canthi__
canthitis1445273canthitis
canthus1248713cant_hus
cantic103920543cant_i_c
cantina93417253cant_ina
cantinas102713783cantinas
canting104725903cant_ing
cantles94721413cant_les
cantons95221203cant_ons
cantorial1149813cantorial
cantors94620753cant_ors
cantos84826973cant__os
cants77036943cant___s
cantus85117763cant__us
capris10415083ca_pri_s
captains121810573captains
caries85147623ca__ries
carps96932253ca__r_ps
carries94328013ca_rries
catkins133012563ca_tkins
catlins93818843ca_tlins
catnaps1197033ca_tnaps
catnip1097973ca_tnip_
catsups1135343ca_tsups
cattails1038553cattails
catteries11815523catteries
catties94023053ca_tties
cauteries11615393cauteries
centrals102712033centrals
centres93817123centr_es
centric11312403centri_c
centring112112953centring
centrings12227603centrings
centrism1249643centrism
centrisms1348053centrisms
centrist10314863centrist
centrists11410233centrists
centroids1247043centroids
centrums1236913centrums
centuries11311333centuries
chanties132615803chant_ies
chytrids1744223chytrids
cinerins10414103cinerins
citrins92614363c_itrins
claptraps1542693claptraps
contains10316533contains
contrails11410543contrails
contras93015623contr_as
contrite10318543contrite
contrive13311353contrive
contrives14311703contrives
controls10311393controls
countries11313613countries
entraps9109763_entraps
entries71523163_entries
fantails1139693fantails
gastrins9310123gastrins
gauntries1046033gauntries
gentries91315263gentries
handgrips1643643handgrips
latrias71913213la_trias
mandrils1138493mandrils
mantids103113623mant_ids
mantis83926033mant_i_s
mantrams12288963mantrams
mantrap11379823mantrap_
mantras93815863mantr_as
mantric11311353mantri_c
panfries13149203panfries
panties94230933pant_ies
pastries101517423pastries
rattraps1044823rattraps
sangrias938373sangrias
santerias9311843santerias
santims9312603sant_ims
santirs7312963sant_irs
satraps95011643sa_traps
scanties103215423scant_ies
sentries81318053sentries
strips85719653__strips
tantras73112093tantr_as
tantric939593tantri_c
tantrism1048373tantrism
tantrisms1146323tantrisms
tantrums1045113tantrums
trips74923363___trips
unrips8199453_un_rips
untrims938613_untrims
wastries111212883wastries
xanthins1846943xanthins
yantras10259003yantr_as

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621407.22020244.0
3Display Results1401400.0632222.2
 (SQL Overall)1786911407.71923149.5
 
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.