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

256 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
cravats123740(None) 
cravat11314441cravat_
bravas114913322brava_s
carats85929022c_arats
caravans1338622caravans
caveats1239802c_aveats
clavate1238712clavate
craals84113302cra_als
crafts115312742cra_fts
cravens124010122cravens
cravers124416562cravers
craves115825392crav_es
rabats83116222_rabats
acrobats1258343acrobats
arhats9312973ar_hats
avast85519363__avast
bracts105617773bra_cts
brants85723053bra_nts
brats75336013br__ats
brava106414793brava__
bravado1343603bravado
bravados1443223bravados
bravers124715523bravers
braves115524083brav_es
bravest124211753bravest
bravoes12418533bravoes
bravos114711393brav_os
brazas175812433braza_s
brevets12519393brevets
cabals104020153c_abals
cacaos104616183c_acaos
cacas95627983c_aca_s
cadets96316513c_adets
camas96333523c_ama_s
camass104114183c_amass
canals84421663c_anals
cants77036943c_a_nts
canvas113813333canva_s
canvass12376873canvass
carabaos1238083carabaos
caracals12310753caracals
carat75048793c_arat_
carate84734003c_arate
carates95630613c_arates
caravan1239233carava_n
caravels1337443caravels
caraways1636953caraways
carcass11310513carcass
carets85330773c_arets
caritas93316953caritas
carnets93918403carnets
carpals113414623carpals
carpets113915333carpets
carrots9714623carrots
carts78946293c_a_rts
carvels124914593carvels
carvers124817543carvers
carves115128453carv_es
casas75327843c_asa_s
casavas1237823casava_s
casts77237793c_a_sts
cats66356343c___ats
caveat11417723c_aveat_
cavers115026843c_avers
caves105639703c_av_es
caviars1238623c_aviars
cavies114525003c_avies
cavils114014393c_avils
cavity14310013c_avity
cavorts1237933c_avorts
ceramals1246513ceramals
chadars1338293chadars
chalahs15289883chalahs
chalets122813473chalets
chants115020393cha_nts
chapati14118023chapati
chapatis15127943chapatis
charas114223613chara_s
charts115823093cha_rts
chats105730093c__hats
chaunts1267083chaunts
chazans21268123chazans
cheats114519543c_heats
civets115212543c_ivets
clarets94111103clarets
clasts84817293cla_sts
clavers124314903clavers
claves115020063clav_es
clavus11347353clav_us
cleats84919313c_leats
coacts105314333coa_cts
coaevals1344553coaevals
coalas87418963coala_s
coapts104614013coa_pts
coasts85719143coa_sts
coats75635003c__oats
coevals1237873coevals
combats13311683combats
corvets124715023corvets
covets114819643c_ovets
cowpats1437713cowpats
craal74117753cra_a_l
crabmeats1542993crabmeats
crabs95421393cr__abs
cracks144817003cra_cks
cradles103114133cradles
craft105327663cra_ft_
crafty14478913cra_fty
crags85622573cr__ags
crakes124921813cra_kes
crambes1339963crambes
crambos1336783crambos
crampits1436273crampits
cramps125615563cra_mps
crams96229153cr__ams
cranes84330753cra_nes
craniate10312563craniate
craniates11310653craniates
cranks125015313cra_nks
crapes104727693cra_pes
craps95328643cr__aps
crases85532313cra_ses
crashes124618403crashes
crasis85020473cra_sis
crass76328043cr__ass
crate76537403cr__ate
craters95021893craters
crates85736063cra_tes
cratons94316033cratons
crave105626313crav__e
craved125417773crav_ed
craven114113933crav_en
craver114618473crav_er
craving134015733craving
cravings14428223cravings
crawdads1542653crawdads
crawls114712083cra_wls
craws105723123cr__aws
crayons12439233crayons
crazes174720133cra_zes
crazies183413853crazies
creaks124315963cr_eaks
creams104715253cr_eams
create85126383cr_eate
creates95225203cr_eates
credits1039973credits
cremate113816183cremate
cremates124216003cremates
crenate93317113crenate
crests85218703cr_ests
crevasse1343093crevasse
crits75527573cr__its
croaks125812983cr_oaks
crofts114910593cr_ofts
cruets85314953cr_uets
crusets93811043crusets
crusts84916543cr_usts
crypts13397743cr_ypts
curacaos1244923curacaos
curaras93911953curara_s
curvets12399913curvets
cushats12288273cushats
cyanate12259703cyanate
cyanates13238433cyanates
davits104012363_davits
drafts105012533dra_fts
dramas95814653drama_s
drats66628373dr__ats
favas115618593_fava_s
fracas11311993fraca_s
frats86829673fr__ats
gavots1038113_gavots
graals74112913gra_als
gradate9511233gradate
gradates10510783gradates
grafts105013253gra_fts
grahams1335333grahams
gramas94317203grama_s
grants73722473gra_nts
gravels113611143gravels
gravers114515273gravers
graves104624003grav_es
gravest114011633gravest
gravies11314093gravies
gravitas12316013gravitas
gravity1437183gravity
gravlaks1642423gravlaks
greats76318393gr_eats
grivets11357973grivets
groats74816653gr_oats
guavas1037163guava_s
javas155915423_java_s
karats106420493_karats
kavas125919953_kava_s
kavass13517303_kavass
kraals10378433kra_als
krafts13438853kra_fts
kraits104912203kra_its
krauts10418513kra_uts
lariats7615053lariats
larvas9310233larva_s
lavas85422223_lava_s
lovats939073_lovats
manats84623463_manats
navars92810573_navars
orgeats838353orgeats
pavans115715593_pavans
praams10459643pra_ams
prats76333393pr__ats
private121513263private
privates131812373privates
privets122910053privets
qanats154112813_qanats
rabat72832223_rabat_
rabato83413263_rabato
rabatos93010903_rabatos
radars71314673_radars
rafts87820633_ra_fts
ragas65326063_raga_s
raias54631123_raia_s
raitas64417673_raitas
rajahs16497663_rajahs
rajas127317723_raja_s
ramate83921683_ramate
ramets83517393_ramets
rants55935343_ra_nts
ratals64219583_ratals
ratans63819373_ratans
rats46260373_r__ats
ravage1039303_ravage
ravages1139403_ravages
ravels94717073_ravels
ravens93916883_ravens
ravers94628183_ravers
raves85441973_rav_es
ravins94622563_ravins
rayahs12579193_rayahs
rayas85922053_raya_s
revets94022173_revets
rivals94213183_rivals
rivets94417113_rivets
savants1038653_savants
savate9313783_savate
savates10312953_savates
tracts85019073tra_cts
traits65121983tra_its
trapans92812463trapans
travail1036553travail
travails1146083travails
travels104711293travels
traves94222743trav_es
travois1037883travois
treats64821693tr_eats
trevets10499973trevets
trivets103911583trivets
vats76841743___vats

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.390458182.1
2DLD Change Limit1340272567.23318529.9
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.71623158.5
 
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.