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

174 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
cantrap11331028(None) 
caltrap11297941caltrap
cantraip12326391cantraip
cantraps12319111cantraps
cantrip112910041cantrip
mantrap11379821mantrap
antra56521922_antra_
antral65719412_antral
caltraps12327252caltraps
caltrop11267642caltrop
cantal84122032cant_al
canthal12410052canthal
cantraips13255272cantraips
cantrips12318932cantrips
catnap1098382ca_tnap
centra84113882centra_
central93114472central
claptrap1442902claptrap
contra83314702contra_
contras93015622contras
entrap8710562_entrap
mantra84116092mantra_
mantram114011602mantram
mantraps12298062mantraps
mantras93815862mantras
rattrap945262rattrap
satrap86212552sa_trap
tantra63713352tantra_
tantras73112092tantras
yantra9449622yantra_
yantras10259002yantras
acantha1254663acantha_
acanthae1343373acanthae
amtrac10109133_amtrac
anorak1038923_anorak
anta46839583_ant_a_
antae56828293_ant_ae
antas55432033_ant_as
anthrax1757153_anthrax
antiar6317173_antiar
antirape10410113_antirape
antre55224523_antr_e
antres65021003_antres
antrum8611313_antrum
anural65714743_anural
anuran64313243_anuran
astral66919283_astral
astray95615543_astray
atap66722453_a_t_ap
atrip75315753_a_trip
bantam10314063bant_am
caftan111710123caft_an
calthrop1563553calthrop
caltrops12307863caltrops
camera10313693camera_
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
canal75428043can__al
canape10913513can__ape
canard9314763canar_d
canards10311203canards
canary11314693canar_y
cancan10314103can_can
cancha134411613cancha_
canchas143212403canchas
caner75334773caner__
caners84629203caner_s
canna75919333can_na_
cannas84518403can_nas
canola8313623canola_
canolas9313993canolas
cant66362033cant___
cantala94114673cantala
cantalas104013523cantalas
cantals93919573cantals
cantata93811813cantata
cantatas103410093cantatas
cantdog1134573cantdog
canted94825783cant_ed
canteen9411083canteen
canter85230113cant_er
cantered113415983cantered
canters94827733canters
canthi11310973cant_hi
canthus1248713canthus
cantic103920543cant_ic
cantina93417253cantina
cantinas102713783cantinas
canting104725903canting
cantle84522153cant_le
cantles94721413cantles
canto74931013cant__o
canton85722993cant_on
cantonal1038903cantonal
cantons95221203cantons
cantor85621523cant_or
cantorial1149813cantorial
cantors94620753cantors
cantos84826973cant_os
cants77036943cant__s
cantus85117763cant_us
canty105226803cant__y
canula8312963canula_
canulae9311183canulae
canular9310323canular
canulas9312853canulas
canvas113813333can_vas
caporal11410943caporal
captan101613343capt_an
carat75048793ca__rat
carp85139813ca__r_p
cartop104213563cart_op
castrate10313863castrate
castrati1048643castrati
castrato1048523castrato
cateran9313773cateran
catnaps1197033ca_tnaps
catnip1097973ca_tnip
catsup1036433ca_tsup
centai84814783cent_ai
cental84420963cent_al
centare93113703centare
centas85020703cent_as
centrals102712033centrals
centre84316643centr_e
centred103411683centred
centres93817123centres
centric11312403centric
centrum1168603centrum
chantry15388223chantr_y
chinstrap1652613chinstrap
citral81113893c_itral
claptraps1542693claptraps
contract122915633contract
contrail10410983contrail
contrary1347493contrary
contrast102614783contrast
control9310693control
crap85731843c___rap
entraps9109763_entraps
enwrap1185213_enwrap
flytrap1543253flytrap
gantry103810113gantr_y
gastral8329553gastral
inwrap11115903_inwrap
kantar10311153kant_ar
kantars11310033kantars
manta75629913mant_a_
mantas85725363mant_as
manteau937863manteau
mantrams12288963mantrams
mantric11311353mantric
mantua84412023mantua_
mantuas93410993mantuas
pangram1239023pangram
pantry115014103pantr_y
rattraps1044823rattraps
santera7311303santera_
santeras8311063santeras
satraps95011643sa_traps
satrapy12497933sa_trapy
strap77925263__strap
tangram1038073tangram
tantara72410823tantara
tantaras8269543tantaras
tantric939593tantric
tantrum946683tantrum
trap67532803___trap
unstrap946783unstrap
unwrap11126323_unwrap
ventral103612173ventral
watap102111673wa_t_ap
xanthan1736013xanthan

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271746.51320578.4
3Display Results1741740.0503480.0
 (SQL Overall)1786911746.98625578.4
 
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.