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

124 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
crash10912001(None) 
brash106221561brash
cash96636281c_ash
clash106219031clash
crass76328041crass
crush106815991crush
rash76039931_rash
trash86119761trash
abash106016512abash
ash67944602__ash
awash116613162awash
bash915240162_bash
brach126123302brach
bras65746452bras_
brashy145210592brashy
brass75428022brass
brush105917472brush
calash11312432calash
caph116623292c_aph
cars67364762cars_
carse74934332carse
carwash1536002carwash
casa65630862c_asa
case65848082c_ase
cask105626432c_ask
cast67159902c_ast
cease75227652cease
chase105127122chase
chasm125518792chasm
clach124617822clach
clasp95517192clasp
class75525482class
clast76030582clast
coach125919452coach
coast75236272coast
cosh96127622c_osh
craal74117752craal
crab85727672cra_b
crabs95421392crabs
crack134120532crack
craft105327662craft
crag75625302cra_g
crags85622572crags
crake114823522crake
cram85635492cra_m
cramp115120692cramp
crams96229152crams
cranch133613532cranch
crane75331602crane
crank114819612crank
crap85731842cra_p
crape96128442crape
craps95328642craps
crases85532312crases
crashed134214212crashed
crasher124616162crasher
crashes124618402crashes
crasis85020472crasis
cratch134110792cratch
crate76537402crate
crave105626312crave
craw97725262cra_w
crawl104916712crawl
craws105723122craws
craze165221462craze
crazy195511222crazy
crease85519572crease
creasy114612302creasy
creesh11328332creesh
cress75022832cress
crest74632692crest
cris66233432cris_
crisp95014622crisp
cross75124502cross
crus65828482crus_
cruse75726102cruse
crust75827662crust
crwth1337482crwth
cuish10313172cuish
curagh1236552curagh
dash87031632_dash
deash95617242deash
eras45441502eras_
erase54925492erase
fash107232292_fash
flash115716212flash
frass85321122frass
fresh115012202fresh
frosh115713402frosh
gash86833022_gash
gnash9449832gnash
graph115315612graph
grasp84814482grasp
grass66125202grass
harsh116418052harsh
hash106936502_hash
lash76539652_lash
leash85519212leash
marsh105320852marsh
mash96039402_mash
orach105219232orach
pash95638132_pash
plash104616562plash
prase76128752prase
quash174512162quash
rah68052402_ra_h
ras37575392_ras_
rase46149982_rase
rasp66029162_rasp
rath76037662_rath
resh76523452_resh
rush76628182_rush
sash77235302_sash
slash84719682slash
smash104814432smash
snash84815672snash
stash84916972stash
swash116316752swash
thrash12258362thrash
trashy12509052trashy
trass56226472trass
urase54624692urase
wash106033812_wash
wrath115715872wrath

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.703254183.5
2DLD Change Limit538001242.54621131.2
3Display Results1241240.0333757.6
 (SQL Overall)1786911243.28254445.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.