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 “cravers” 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
cravers12441655(None) 
bravers124715521bravers
carvers124817531carvers
cavers115026841c_avers
clavers124314901clavers
craters95021891craters
cravens124010111cravens
craver114618461craver_
craves115825391crave_s
gravers114515271gravers
ravers94628181_ravers
avers85127312__avers
beavers124417322beavers
bracers114616702bracers
braver114719042braver_
bravery15428132bravery
braves115524082brave_s
brayers124511902brayers
brazers184513942brazers
cabers105023922c_abers
cadavers1435882cadavers
cagers95624192c_agers
caners84629202c_aners
capers105428142c_apers
caravels1337432caravels
carders104820352carders
careers95218782careers
carers85133962c_arers
carpers114521252carpers
carters95327252carters
carvels124914592carvels
carver114420142carver_
carves115128452carve_s
caters85336502c_aters
caver105629062c_aver_
cavern115312452c_avern
caverns124510252c_averns
caves105639702c_ave_s
chafers154512742chafers
chasers123714922chasers
chawers154412052chawers
claver113816972claver_
claves115020062clave_s
claviers1367102claviers
clawers123910972clawers
cleavers13398872cleavers
clivers123411752clivers
clovers125114662clovers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
covers114627962c_overs
crabbers14358752crabbers
crackers164111722crackers
cradlers11309202cradlers
crafters13419952crafters
crakes124921812crake_s
crammers14369352crammers
cranes84330752crane_s
crapes104727692crape_s
crappers144011022crappers
crases85532312crase_s
crashers134013232crashers
crater85026642crater_
crates85736062crate_s
cravats1237392cravats
crave105626312crave__
craved125417772crave_d
craven114113932crave_n
crawlers13309012crawlers
crazes174720132craze_s
creamers124111312creamers
creasers103612832creasers
criers83918582cr_iers
croakers14288522croakers
crowers124614902crowers
crozers184111082crozers
culvers12329832culvers
drapers105313352drapers
drawers113610072drawers
drivers114412792drivers
drovers115212642drovers
erasers74413942erasers
framers125113822framers
fraters103517212fraters
graders94716012graders
graters85419742graters
gravels113611142gravels
graver105018592graver_
graves104624002grave_s
grazers175112452grazers
havers124721482_havers
heavers133717192heavers
kraters114212342kraters
lavers94526362_lavers
leavers103717782leavers
pavers115021822_pavers
praters94921652praters
prayers124212852prayers
preavers13910262preavers
provers123817792provers
quavers19309012quavers
racers84725432_racers
rakers104123572_rakers
rapers84327182_rapers
rasers64526782_rasers
raters63936582_raters
ravels94717072_ravels
ravens93916882_ravens
raver85631492_raver_
raves85441972_rave_s
razers154919612_razers
reavers108320742reavers
revers94529632_revers
rivers94626542_rivers
rovers95423522_rovers
savers93825922_savers
scrapers125510532scrapers
shavers134115092shavers
slavers103716502slavers
tracers94917842tracers
traders84316952traders
travels104711292travels
traverse1136212traverse
traves94222742trave_s
trovers103713322trovers
wavers125022472_wavers
weavers133714462weavers

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 Filter1786911076710.376475242.0
2DLD Change Limit1076711283.25033129.5
3Display Results1281280.0462782.6
 (SQL Overall)1786911283.67248663.1
 
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.