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

158 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
carabines1331147(None) 
carabine12412391carabine_
carabiner1346341carabiner
carabiners1445071carabiners
carabins12312361carabin_s
carbines123617541car_bines
arabizes1969102_arabizes
calamines13312222calamines
carabids1338192carabi_ds
carabin11313212carabin__
carabineer1452992carabineer
carabineers1552512carabineers
carabinero1452372carabinero
carabineros1551892carabineros
carabinier1444012carabinier
carabiniers1552832carabiniers
carbides133111692car_bides
carbine112918642car_bine_
carlines103521652car_lines
carmines123617872car_mines
curarines11710552curarines
karabiner1543242karabiner
karabiners1642692karabiners
acarines10314343_acarines
acrasins1039973acrasin_s
acridines1247723acridines
alanines8314803_alanines
arabicas1247193_arabicas
arabinose1144063_arabinose
arabinoses1244443_arabinoses
arabize1849343_arabize_
arabized2047173_arabized
arables91814973_arab_les
archines133815253_archines
arcsines104010343_arcsines
arsines73518813_ar_sines
atabrines1144463_atabrines
atrazines1846683atrazines
barbies114519593bar_bi_es
cabbies133115163ca_bbi_es
cabined1239993c__abined
cabinet11318903c__abinet
cabinets1238283c__abinets
cabins104418923c__abin_s
caffeines1743913caffeines
calamine12314033calamine_
calamined1447433calamined
calamints1348053calamints
calamites13410713calamites
calcines12314753ca_lcines
camphines1847563camphines
canakins142010463canakin_s
canalises11515493canalises
canalizes201113783canalizes
canaries10318943canari_es
canines93724033c__anines
cannabins1365783cannabin_s
cannabises1444433cannabises
cantabiles1445763cantabiles
carabaos1238083carab_aos
carabid12311333carabi__d
carabiniere1552073carabiniere
carabinieri1551863carabinieri
caracoles13310083caracoles
carafes125015703cara__fes
caraganas1245793caraganas
carageens1264723carageens
carapaces1546053carapaces
carapaxes2044833carapaxes
carates95630613cara__tes
caravaned1544993caravaned
caravaner1444743caravaner
caravaners1544143caravaners
caravans1338623caravan_s
carbamides1745133carbamides
carbarns1238563carbarn_s
carbide126112493car_bide_
carbineer1344763car_bineer
carbineers1444233car_bineers
carbinol1245783car_binol
carbinols1346123car_binols
carbons115418943car_bon_s
cardings123812643car_dings
caribes113715643car__ibes
carices114220953car__ices
caries85147623car__i_es
carinas93622413car__inas
carline93923613car_line_
carlings114015863car_lings
carlins93921923car_lin_s
carmine112918483car_mine_
carnies94123963car_ni_es
carnitines1277813carnitines
carotenes11410203carotenes
carotins102315583carotin_s
carpings133812393car_pings
carries94328013car_ri_es
carvings143810213car_vings
caryatides1644493caryatides
cassines103116613ca_ssines
catamites1349363catamites
cavatinas1444783cavatinas
cavatine13310323cavatine_
ceramides1447453ceramides
ceratins102818733ceratin_s
chaines124518733c_ha_ines
charabancs1952613charabancs
characins1647593characin_s
cocaines121314443coca_ines
combines142814623c_ombines
corallines1246553corallines
corbies113520123cor_bi_es
corbinas12229403cor_binas
cranes84330753c_ra__nes
crannies10313013c_rannies
cravings14428223c_ravings
crazies183413853c_razi_es
craziness2037383c_raziness
creatines112814433creatines
curacies12311763curaci_es
curarine10610713curarine_
curarizes2078173curarizes
curatives1437823curatives
curbings13407313cur_bings
cyanines132710543c_yanines
darbies104216983dar_bi_es
faradises13248983faradises
faradizes22237443faradizes
gradines103615253_gradines
harmines132715143har_mines
magazines2145633magazines
margarines1347203margarines
marines93928013mar__ines
marlines103818713mar_lines
moraines10314363mora_ines
narceines1146583narceines
palatines11313043palatines
parabioses1445283parabioses
parables121613563parab_les
paradises122513203paradises
paraffines1844323paraffines
parakites1549543parakites
parasites11313153parasites
paravanes1448303paravanes
parawings1535823parawings
pralines102217723_pralines
rabies85226023__rabi_es
rapines95120863__rapines
ratines75328583__ratines
ravines104220233__ravines
sabines94318483__sabines
safranines1344083safranines
sarabandes1344093sarabandes
sarabands1245593sarabands
sardines92815573sar_dines
turbines1039903tur_bines
tyramines1447213tyramines
zaratites1847003zaratites

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411586.92321470.6
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.40624127.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.