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

102 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
carotene103913(None) 
carotenes11410201carotenes
carotin92216712carotin_
carotins102315582carotins
acrogen1038193acrogen_
acrogens1147243acrogens
arene55329413_ar__ene
baritone1058643baritone
baronne938263baro_nne
bartend1038753bar_tend
barytone1356023barytone
cabotage1345223cabotage
calotte9510563calot_te
calotype1544323calotype
camphene1746613camphene
canteen9411083ca_nteen
capote10315733capot__e
capotes11314643capote_s
capstone1237653capstone
carabine12412383carabine
carageen1155633carageen
carate84734003carat__e
carates95630603carate_s
carbine112918643car_bine
careen84119493car_een_
careened1139193car_eened
careener1039323car_eener
careens94514703car_eens
caretake1446773caretake
carline93923613car_line
carmen104019343car_men_
carmine112918483car_mine
carnitine1178573carnitine
carnotite1147353carnotite
caroche1469243caro_che
caroled103717683carole_d
caroler93816753carole_r
carolers103314173carolers
caroling113317003caroling
caromed123713623carome_d
caroming133312963caroming
carotenoid1353863carotenoid
carotid102014813carot_id
carotids11229933carotids
carouse9614423caro_use
carrotin102210883carrotin_
carrotins11239953carrotins
cartage10312593car_tage
carte75940423car_t__e
carted98631443car_te_d
cartel85022533car_te_l
cartels94618123car_tels
carter84932273car_te_r
carters95327243car_ters
cartes86239473car_te_s
carting104228283car_ting
carton84522663car_ton_
cartoned111312833cartoned
cartons94122473car_tons
cartoon94114463cartoon_
cartooned1246313cartooned
cartoons104012803cartoons
cartoony13377403cartoony
carven114716663car_ven_
caryotin13268343caryotin_
caryotins14248043caryotins
cassene93111543ca_ssene
catena8312473ca__tena
catenae9311363ca__tenae
cavatine13310323cavatine
cerotype1544653cerotype
chorten122811303chorten_
chortens13308793chortens
corotate102813933corotate
cortege1098943cor_tege
croceine1248033c_roceine
crocine11314153c_rocine
crone75231333c_ro__ne
croton84415453c_roton_
crotons93714373c_rotons
cymogene1644723cymogene
earstone848603earstone
garote7717943garot__e
garoted9710133garote_d
garotes8614563garote_s
garoting10510703garoting
garotte868703garot_te
gasogene1045303gasogene
gasolene945553gasolene
gazogene1943553gazogene
haptene123810933ha_ptene
kerosene1254823kerosene
marten84518263mar_ten_
martens93714953mar_tens
parolee94119633parole_e
propene112716043_propene
protege1059153_protege
protend104012793_protend
pyroxene2045083pyroxene
retene69224273__retene
serotine8313563serotine
zygotene2142523zygotene

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.1731032896.0
2DLD Change Limit1461621027.95318378.2
3Display Results1021020.0303400.0
 (SQL Overall)1786911028.15621909.1
 
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.