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

178 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
cabaret11251904(None) 
cabarets12268471cabarets
tabaret92717311tabaret
cabernet12410762cabernet
cabinet11318902cabinet
cablet104429462cab_let
carburet12411112carburet
caret75360562c__aret
cigaret10413002cigaret
claret84026572c_laret
labret8320222lab_ret
lazaret16411782lazaret
tabarets10287242tabarets
taboret92916112taboret
abaft10318063_aba_ft
abase76023483_abase_
abased96514993_abased
abaser86414343_abaser
abases85720773_abases
abate76627843_abate_
abated95918453_abated
abater85518123_abater
abates85825043_abates
abet610547943_ab__et
abort76133583_abor_t
aigret73720023_aigret
apart74330673_apar_t
aware86420023_aware_
barbet104427883__barbet
bare65460523__bare_
bared85144483__bared
barer74535803__barer
bares75457133__bares
barest85327693__barest
barret84930493ba_rret
beret74946363__beret
buret77444013__buret
cabal95222153caba__l
cabala103516913caba_la
cabalas113516003cabalas
cabaletta1343443cabaletta
cabalette1344893cabalette
cabalist12314503cabalist
caballed1337163caballed
cabals104020153caba_ls
cabana103913563caba_na
cabanas112413033cabanas
cabbage1446983cabbage_
cabbaged1644383cabbaged
cabbages1537203cabbages
cabbagey1843213cabbagey
cabbed135416263cab_bed
cabbie122913353cabbie_
cabbies133115163cabbies
caber95126833cab__er
cabernets1345063cabernets
cabers105023923caber_s
cabined1239993cabined
cabinets1238283cabinets
cable95329913cab_le_
cabled114819873cab_led
cabler104519173cab_ler
cablers114416713cablers
cables104527553cab_les
cablets114216343cab_lets
cabmen123610653cab_men
cabresta1243993cab_resta
cabresto1243743cab_resto
cabretta1244843cab_retta
cachet134526413ca_chet
cadaver1335793cadaver
cadet85339343c__adet
cadre85419023ca_dre_
cadres94017933ca_dres
cajaput1844963cajaput
callet84536763ca_llet
calumet11313293calumet
camases114216343camases
cambered15129003cambered
camlet104426583ca_mlet
canaled103615563canaled
canape10913523canape_
canapes111213083canapes
canard9314763canar_d
canards10311203canards
canaries10318943canaries
canary11314693canar_y
capelet11517073capelet
capered123014043capered
caperer113013403caperer
caplet104226813ca_plet
carafe115416163carafe_
carafes125015713carafes
caramel11310253caramel
carat75048803c__arat
carate84734003carate_
carates95630613carates
caravel1238213caravel
carbarn1139453carbar_n
carbarns1238563carbarns
carbaryl1544423carbaryl
carburets1345203carburets
carcanet12316353carcanet
care66968373c__are_
cared86050093c__ared
carer74942333c__arer
cares77369183c__ares
carets85330773c__arets
carex144822303c__arex
carfare12310073carfare_
carfares13310323carfares
carnet84732873ca_rnet
carpet104530093ca_rpet
carrel84718633ca_rrel
carrot8423123ca_rrot
cart66570343c__ar_t
carte75940423c__arte
casket124820993ca_sket
castanet10416193castanet
cataract1249413cataract
catarrh1245013catarrh
catered103117783catered
caterer92815953caterer
caviare1238373caviare_
caviares1337993caviares
cavort11316173cavor_t
cellaret103713583cellaret
chalet113825993c_halet
chare105231983c_hare_
chared125423693c_hared
chares115631803c_hares
chart105038283c_har_t
chevret153310633chevret
cigarets1145473cigarets
clarets94111103c_larets
cleared103612463cleared
clearer93710823clearer
clearest1038653clearest
cobalt10317393coba_lt
coffret15310073coffret
collaret103116703collaret
coparent12412253coparent
cubage1178273cubage_
cubages1237923cubages
curare84916953curare_
curares94916853curares
curet75447643c__uret
gabbart1248883gabbar_t
garret74426563ga_rret
imaret81121233_imaret
kabar114815563kabar__
kabars124513953kabar_s
labara83712893labar_a
labarum1166013labarum
labored102810253labored
laborer9249513laborer
labrets939373lab_rets
lazarets1744803lazarets
minaret9520683minaret
parapet11317643parapet
rabat72832223raba__t
rabbet103818653rab_bet
sabered103213023sabered
sabre74821503sab_re_
sabred95916533sab_red
sabres85520863sab_res
scalare93311843scalare_
scalares103210983scalares
subarea939413subarea
tabard9313333tabar_d
tabarded1234743tabarded
tabards10310383tabards
tabered103311593tabered
tablet84227643tab_let
tabored102810563tabored
taborer9269293taborer
taborets10278073taborets
tabouret1049173tabouret

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 Limit1340271786.83019623.3
3Display Results1781780.0762342.1
 (SQL Overall)1786911787.31224438.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.