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 “carat” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
carat7504879(None) 
carate84734001carate
carats85929021carats
caret75360561caret
cart66570341car_t
karat96837591karat
arak86929572_arak
arhat8327092_arhat
art38679142_ar_t
brat66055542_brat
cabal95222152cabal
caca85528082caca_
cacao95420002cacao
cacas95627982cacas
cadet85339332cadet
camas96333522camas
canal75428042canal
canst74932212canst
cant66362022ca_nt
caput9823972caput
car59165562car__
carack142113172carack
carafe115416162carafe
carates95630602carates
carb85143162car_b
carbo94923842carbo
carbs96031462carbs
card710245872car_d
cards85137932cards
care66968372car_e
cared86050092cared
carer74942332carer
cares77369182cares
carets85330772carets
carex144822292carex
cargo85322072cargo
cark105539272car_k
carks115534212carks
carl65144782car_l
carle74535702carle
carls77037422carls
carman103920742carman
carn66245432car_n
carnal83919202carnal
carnet84732872carnet
carns75937562carns
carny105822922carny
carob95325222carob
carol75128612carol
carom95025562carom
carp85139812car_p
carpal103716252carpal
carpet104530092carpet
carpi94319392carpi
carps96932252carps
carr65434702car_r
carrot8423122carrot
carrs75730852carrs
carry105823782carry
cars67364762car_s
carse74934332carse
carte75940422carte
carts78946292carts
carve106227752carve
casa65630862casa_
casas75327842casas
cast67159902ca_st
cat58282342c__at
caveat11417722caveat
cerate84829462cerate
charas114223592charas
chart105038282char_t
chat95546132c_hat
cheat105732452cheat
claret84026572claret
cleat76335062cleat
coat67558342c_oat
coral76033452coral
craal74117752craal
crab85727672c_rab
craft105327662craft
crag75625302c_rag
cram85635492c_ram
crap85731842c_rap
crate76537402c_rate
cravat11314442cravat
craw97725262c_raw
crit65743712c_rit
curate85226242curate
curet75447642curet
curst74931022curst
curt67051712cur_t
dart55857872dar_t
derat65044082derat
drat56247832_drat
farad95720672farad
fart76860562far_t
frat75648542_frat
grat55651282_grat
hart76865772har_t
jurat124829322jurat
karate105320922karate
karats106420492karats
karst97228992karst
kart86750802kar_t
korat94934432korat
lariat6629042lariat
manat76039982manat
mara67444562mara_
maras75443282maras
mart66865972mar_t
para65242172para_
parae76335702parae
paras76143042paras
part65967462par_t
prat65952042_prat
qanat144426842qanat
rabat72832222rabat
rat37892742__rat
saran53730302saran
scarab10310062scarab
scart76139772scar_t
sprat76635972sprat
tarot55943932tarot
tart47566182tar_t
vara75530882vara_
varas86028192varas
wart77866082war_t

Search took 4 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 Filter178691538000.0931921408.6
2DLD Change Limit538001283.11017299.0
3Display Results1281280.0632031.7
 (SQL Overall)1786911283.26654712.5
 
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.