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

245 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
carabin1131321(None) 
carabid12311331carabid
carabine12412381carabine
carabins12312351carabins
acrasin9311222acrasin
arabic10312732_arabic
cabin94820942c__abin
canakin131810832canakin
cannabin1266432cannabin
carabao1139672carabao
carabids1338192carabids
carabiner1346332carabiner
carabines13311462carabines
caravan1239222caravan
carbarn1139452carbarn
carbine112918642car_bine
carbon104919042car_bon
carlin84421822car_lin
carotin92216732carotin
ceratin93020162ceratin
characin1547992characin
acrasia9310033acrasia
acrasins1039973acrasins
again65218123_aga_in
alanin6317273_alanin
amain74922913_ama_in
arabica1147283_arabica
arabize1849343_arabize
arable81821003_arable
aramid93315613_aramid
arshin9312173_arshin
barbie105018353bar_bie
barbing123716993bar_bing
bargain1079063bargain
brain76229383_bra_in
cabbie122913353ca_bbie
cabbing143613153ca_bbing
cabins104418923c__abins
caffein1535333caffein
cain65643913c__a_in
calami10313423calami_
calamine12314033calamine
calamint12315133calamint
calkin123515493ca_lkin
calpain11310413calpain
camail10314833cama_il
cambia124913153ca_mbia
canakins142010463canakins
canaling112016413canaling
canikin13189753canikin
cannabic1474913cannabic
cannabins1365783cannabins
cannabis1266033cannabis
capable13313363capable
capably1639253capably
capelin11510973capelin
caplin103216303ca_plin
captain112111063captain
carabaos1238073carabaos
carabineer1452983carabineer
carabinero1452363carabinero
carabiners1445063carabiners
carabinier1444003carabinier
caracal11312513caracal
carack142113173cara_ck
caracks152211563caracks
caracol11310423caracol
caracul1138823caracul
carafe115416163cara_fe
carafes125015703carafes
caragana1146273caragana
carageen1155633carageen
caramba1336893caramba
caramel11310253caramel
carangid1246423carangid
carapax1835793carapax
carat75048793cara__t
carate84734003cara_te
carates95630613carates
carats85929023cara_ts
caravans1338613caravans
caravel1238203caravel
caraway1538133caraway
carb85143163car_b__
carbamic1645913carbamic
carbamino1545473carbamino
carbanion1345943carbanion
carbarns1238563carbarns
carbide126112493car_bide
carbines123617533car_bines
carbinol1245773car_binol
carbo94923843car_b_o
carbons115418943car_bons
carbos105122263car_bos
carboy134914183car_boy
carbs96031463car_b_s
cardamon1345553cardamon
cardia9916373car_dia
carding113922433car_ding
cardio9915673car_dio
cardon94120853car_don
cardoon104813813cardoon
careen84119493car_een
caribe103416753carib_e
caribes113715643caribes
caribou1156993caribou
carina84325323car__ina
caring95137993car__ing
carking144322853car_king
carline93923613car_line
carling103727063car_ling
carlins93921913car_lins
carman103920743car_man
carmen104019343car_men
carmine112918483car_mine
carn66245433car___n
carnation11312943carnation
carnie84421093car_nie
carob95325223carob__
carobs104818103carob_s
caroli85918233caroli_
caroling113317003caroling
caroming133312963caroming
carotid102014833carotid
carotins102315583carotins
carpalia1247253carpalia
carpi94319393car_pi_
carping123521083car_ping
carrion9312673carrion
carrotin102210893carrotin
carrying14148373carrying
carryon1237033carryon
cartable121314093cartable
carting104228283car_ting
carton84522663car_ton
cartoon94114463cartoon
carven114716663car_ven
carving133916773car_ving
caryatic1548493caryatic
caryatid1447953caryatid
caryotin13268353caryotin
casaba1079263casab_a
casabas1139983casabas
casein83216453ca_sein
catkin123512383ca_tkin
catlin83819083ca_tlin
cavatina1347333cavatina
cavatine13310323cavatine
ceramic1339823ceramic
ceratins102818733ceratins
certain92612213certain
chain105723673c_ha_in
charabanc1842923charabanc
characid1646863characid
characins1647593characins
coalbin1137533coalbin
cocain101315013coca_in
cohabit1449563cohabit
corban10314693cor_ban
corbie103618203cor_bie
corbina111911453cor_bina
cortin82423153cor_tin
craaling112711353craaling
crab85727673c_rab__
crabbing15287933crabbing
crabby15346753c_rabby
crabs95421393c_rab_s
crania82418433c_rania
craning103620303c_raning
craping124018713c_raping
crasis85020473c_rasis
crating103725203c_rating
craton84517193c_raton
craven114113933c_raven
craving134015733c_raving
crayon114110003c_rayon
crazing193914583c_razing
creatin93618133creatin
cretin82917913c_retin
cumarin1139263cumarin
curable112414513curable
curably142010773curably
curari84414403curari_
curarine10610713curarine
curaris94114773curaris
curating11314293curating
curbing123814023cur_bing
curtain9319793curtain
cyanin113911453c_yanin
cycasin1445903cycasin
drain65222893_dra_in
faradic1337693faradic
galabia1038323galabia
garaging1139043garaging
garbing113613273gar_bing
graben9419723_graben
gradin83517483_gradin
grain65126253_gra_in
gratin74520583_gratin
harmin113117393har_min
harpin113614383har_pin
jacobin1844393jacobin
jalapin1645923jalapin
karabiner1543233karabiner
keratin113314153keratin
manakin131810643manakin
marabou1147493marabou
margarin1148073margarin
margin94016843mar_gin
marlin84220903mar_lin
martin84122523mar_tin
narcein936293narcein
paladin101011773paladin
papain10313793papa_in
parable111819773parable
parading12313863parading
paraffin1644903paraffin
paragon10311023paragon
parawing14310583parawing
rabbin103112303ra_bbin
rabic93817403__rabic
rabid84520783__rabid
rain46251733__ra_in
rarebit948423rarebit
ravin85624653__ravin
rawin85521473__rawin
robin74820283__robin
sabin74924953__sabin
safranin1145213safranin
saraband1146193saraband
saran53730303sara__n
sarin55239253sar__in
savarin10310003savarin
scarab10310063scarab__
scaraboid1443753scaraboid
scarabs1137293scarab_s
scarfpin1553033scarfpin
searobin1045713searobin
sprain83614863spra_in
strain64919573stra_in
tamarin9311913tamarin
train56529113_tra_in
warfarin1444983warfarin
wasabi1154643wasabi_
wasabis1255363wasabis

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.406440125.6
2DLD Change Limit1340272456.76619808.9
3Display Results2452450.0932634.4
 (SQL Overall)1786912457.26524596.1
 
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.