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

131 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
cavatine1331032(None) 
cavatina1347331cavatina
calamine12314032calamine
carabine12412392carabine
cavatinas1444782cavatinas
caveating1539292caveating
creatine103417412creatine
palatine10316072palatine
abating10413973_abating
acarine9316003_acarine
agatize1739833_agatize
alanine7316863_alanine
amative12311733_amative
apatite9312963_apatite
astatine8313533astatine
avarice1238033_avarice
aviating12311023_aviating
basaltine1144713basaltine
caffeine1644513caffeine
calamined1447433calamined
calamines13312223calamines
calamint12315133calamint
calamite12312533calamite
calcine11315273ca_lcine
calmative1647033calmative
calycine1546963calycine
camphine1738373camphine
canakin131810833canakin_
canakins142010463canakins
canaling112016413canaling
canalise10816213canalise
canalize19914493canalize
canine83826703c__anine
cantina93417253ca_ntina
canting104725903ca_nting
canvasing1546433canvasing
caprine11314233ca_prine
capstone1237653capstone
captain112111063captain_
captained1446193captained
captains121810573captains
captive1438973ca_ptive
carabin11313213carabin_
carabiner1346343carabiner
carabines13311473carabines
carabins12312363carabins
carate84734003carat__e
carbine112918643ca_rbine
carline93923623ca_rline
carmine112918483ca_rmine
carnitine1178573carnitine
carotene1039133carotene
carotin92216733carotin_
carotins102315583carotins
carting104228283ca_rting
caseating12311743caseating
cassine93817283ca_ssine
casting104628343ca_sting
catamite12510593catamite
cattie85221023ca_tti_e
catting103922643ca_tting
cauline92215603ca_uline
causative1445833causative
cavalier1348183cavalier
cavelike1738213cavelike
cavie104621593cav__i_e
caviling14310113caviling
caving124822613cav__ing
cavitate13159833cavitate
cavitating1646913cavitating
cavitied14126813cavitied
cavities131412613cavities
cavorting1536063cavorting
ceratin93020163ceratin_
ceratins102818733ceratins
chaine115119223c_ha_ine
cheating144014523cheating
clavate1238713clavat__e
clavation1447003clavation
clavations1546183clavations
cleating113518143cleating
coating103525313c_oating
cobaltine13135613cobaltine
cocaine111315173coca_ine
conative131214623conative
coveting141912303coveting
crating103725203c_rating
creatin93618133creatin_
creatines112814433creatines
creating113921953creating
creatins103617513creatins
creative132812803creative
curarine10610713curarine
curating11314293curating
curative13310403curative
cyanine122911513c_yanine
cystine1239333c_ystine
duvetine1245163duvetine
excavating2344113excavating
galantine1047333galantine
gelatine93213313gelatine
gratine84719193_gratine
hematine131614673hematine
isatine7311763_isatine
lavalike1536283lavalike
lavation1139973lavation
lavations1238973lavations
laxative1845093laxative
legatine91311403legatine
levantine1264793levantine
magazine2046553magazine
palatines11313043palatines
patine85328123__patine
pavane114113443pava__ne
pavonine1346663pavonine
ratine65131823__ratine
ravaging1346323ravaging
ravine95522223rav__ine
saltine75018563sa_ltine
sanative11310473sanative
savaging1356673savaging
savarin10310003savarin_
savarins1139893savarins
savate9313783savat__e
savine94220283sav__ine
saxatile1544953saxatile
sonatine8313323sonatine
vacating14310363vacating
vahine123612113__vahine
valine94623093__valine
zaratite1747793zaratite

Search took 9 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 Limit1461621317.69019006.8
3Display Results1311310.0632079.4
 (SQL Overall)1786911318.18921820.9
 
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.