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

159 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
craver11461847(None) 
braver114719041braver
carver114420151carver
caver105629061c_aver
claver113816971claver
crater85026641crater
crave105626311crave_
craved125417771craved
craven114113931craven
cravers124416561cravers
craves115825391craves
graver105018591graver
raver85631491_raver
aver75931882__aver
beaver114819252beaver
bracer104620582bracer
brave104925502brave_
braved124817442braved
bravers124715522bravers
bravery15428132bravery
braves115524082braves
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
caber95126832c_aber
cadaver1335792cadaver
cager85229222c_ager
caner75334772c_aner
caper94831622c_aper
caravel1238212caravel
carder94524182carder
career85822242career
carer74942332c_arer
carper104923632carper
carter84932272carter
carve106227752carve_
carved124320852carved
carvel114817572carvel
carven114716662carven
carvers124817542carvers
carves115128452carves
cater74840722c_ater
cave95941262c_ave_
caved116227562c_aved
cavern115312452c_avern
cavers115026842c_avers
caves105639702c_aves
chafer144714572chafer
chaser114918382chaser
chawer144314412chawer
clave105420152clave_
clavers124314902clavers
claves115020062claves
clavier1239172clavier
clawer114512782clawer
cleaver124110802cleaver
clever114611532clever
clover114617122clover
coaler84121712coaler
coater84329572coater
coaxer153912792coaxer
cover105430772c_over
crabber133810732crabber
cracker153114172cracker
cradler102910512cradler
crafter124111332crafter
crake114823522crake_
crakes124921812crakes
crammer134010962crammer
crane75331602crane_
craned96121652craned
cranes84330752cranes
cranker133612792cranker
crape96128442crape_
craped116120532craped
crapes104727692crapes
crapper133913192crapper
crases85532312crases
crasher124616162crasher
crasser94114342crasser
crate76537402crate_
crated94827772crated
craters95021892craters
crates85736062crates
cravat11314442cravat
cravens124010122cravens
crawler123510462crawler
craze165221462craze_
crazed184714452crazed
crazes174720132crazes
crazier183610742crazier
creamer113714092creamer
creaser94415742creaser
crier74724462cr_ier
croaker133010682croaker
crower114117562crower
crozer175112842crozer
cruder95612382cruder
culver113010632culver
draper94315692draper
drave95219272drave_
drawer104711362drawer
driver104714492driver
drover104614592drover
eraser64216332eraser
framer114817442framer
frater94520592frater
grader84919692grader
grater74625442grater
grave94624872grave_
graved114818812graved
gravel105313822gravel
graven104513522graven
gravers114515272gravers
graves104624002graves
grayer106014542grayer
grazer164815762grazer
haver115124462_haver
heaver124819672heaver
irater65218352irater
krater104014312krater
laver85031792_laver
leaver94321512leaver
paver104225832_paver
prater84825352prater
prayer114815292prayer
preaver121011612preaver
prover113819722prover
quaver18309312quaver
racer75233022_racer
raker94529792_raker
raper74932752_raper
rarer54731702_rarer
raser55633412_raser
rater54943282_rater
rave75542092_rave_
raved94931432_raved
ravel84621512_ravel
raven84723442_raven
ravers94628182_ravers
raves85441972_raves
rawer84623732_rawer
razer144824272_razer
reaver94524732reaver
river85731692_river
rover85527372_rover
saver84831252_saver
scraper114513422scraper
shaver123718912shaver
slaver94419612slaver
suaver93014232suaver
tracer84820232tracer
trader75218762trader
trave85223032trave_
travel94112982travel
traves94222742traves
trover95014662trover
waver115025702_waver
weaver123916612weaver

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 Filter178691825510.326548131.9
2DLD Change Limit825511592.87328733.4
3Display Results1591590.0503180.0
 (SQL Overall)1786911593.24954998.8
 
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.