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

129 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
calve10591992(None) 
calved125215451calved
calves115119281calves
carve106227751carve
cave95941261ca_ve
clave105420151clave
halve114818921halve
salve85022131salve
valve114515931valve
alae45643752_alae
ale36572342_al_e
alee46652322_alee
alive85722512_alive
alme65832162_alme
aloe45540192_aloe
ave67748702_a_ve
bale66353842bal_e
cable95329912cable
cache125122482cache
cade76443912ca_de
cadge94018792cadge
cadre85419022cadre
cafe95230322ca_fe
cage75339062ca_ge
cake105439962ca_ke
calces104420052calces
calf96339562cal_f
calfs104919382calfs
calif104929102calif
calix145317352calix
calk105527662cal_k
calked134617402calked
calker124917082calker
calks115421602calks
call66838672cal_l
calla74827072calla
called94126732called
callee84327292callee
caller85125482caller
callet84536762callet
calls75634732calls
calm85032362cal_m
calmed114816382calmed
calmer105216932calmer
calms95222352calms
calo64936442cal_o
calos74431902calos
calque17289842calque
calx135722792cal_x
calxes154113032calxes
calyx17518192calyx
came87648752ca_me
cane66653122ca_ne
canoe75627252canoe
cape87242782ca_pe
care66968372ca_re
carle74535702carle
carse74934332carse
carte75940422carte
carved124320852carved
carvel114817572carvel
carven114716662carven
carver114420152carver
carves115128452carves
case65848082ca_se
caste75932362caste
cate66254602ca_te
cause75225352cause
caved116227562ca_ved
caver105629062ca_ver
caves105639702ca_ves
cavie104621592cavie
cavy125920002ca_vy
chive135117622chive
clade85821012clade
claver113816972claver
claves115020062claves
clavi104912922clavi
clove105619442clove
clue65324532c_lue
cole66956112col_e
cove95837072c_ove
crave105626312crave
culver113010632culver
curve104920022curve
dale55643982dal_e
delve96018262delve
eave75733582ea_ve
false84818122false
fauve114712072fauve
fave105532962fa_ve
gale56347322gal_e
gave84634052ga_ve
hale76052832hal_e
halva115414432halva
halved134813902halved
halves124717092halves
have106137072ha_ve
helve115018092helve
kale86533752kal_e
lave75642142la_ve
male66052302mal_e
mauve104013272mauve
naive85116212naive
nave75732312na_ve
pale66055012pal_e
parve109824852parve
pave96133892pa_ve
rale45050562ral_e
rave75542092ra_ve
sale44959702sal_e
salved103916422salved
salver94617752salver
salves94221762salves
salvo84415642salvo
save75741362sa_ve
scale74629142scal_e
slave84224032slave
solve85618942solve
tale46154162tal_e
vale74937342val_e
valse85117522valse
value85719092value
valved136711042valved
valves124113782valves
varve115716852varve
waive114214602waive
wale74546432wal_e
wave105234732wa_ve

Search took 2 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.296603685.8
2DLD Change Limit538001291.64032804.9
3Display Results1291290.0333909.1
 (SQL Overall)1786911291.96990752.2
 
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.