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

194 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
crow9642813(None) 
brow97228441brow
chow125820991chow
cow89856711c_ow
craw97725261craw
crew96122671crew
croc85723731croc
crop87628631crop
crowd115815621crowd
crown105620081crown
crows105727311crows
frow106425051frow
grow86127301grow
prow97030381prow
row67453671_row
trow78031421trow
vrow105817471vrow
alow75328592alow
arrow83414882arrow
avow107816462avow
blow95827192blow
bow87051902_bow
braw94829562braw
brew95023562brew
bro56236602bro_
broo65129822broo
bros65635662bros
brown105619532brown
brows105425982brows
cahow135110942cahow
carob95325222carob
carol75128612carol
carom95025562carom
caw86647932c_aw
cero66329452cero_
ceros74726072ceros
chaw126224632chaw
chew126622132chew
chon96627792chon
chop116024922chop
chows135618202chows
cion613330912cion
claw95624342claw
clew95520572clew
clod76124612clod
clog76123242clog
clon66232482clon
clop86929892clop
clot66542422clot
clown105214732clown
cloy96623832cloy
cob710258752c_ob
cod69660122c_od
cog69552902c_og
col59360352c_ol
con510268022c_on
coo59566362c_oo
coof96643272coof
cook107236932cook
cool66940492cool
coon67248942coon
coop87238652coop
coos67456492coos
coot67860382coot
cop711162372c_op
cor59960942c_or
cord76740922cord
core67263112core
corf95941482corf
cork106635692cork
corm85735372corm
corn69945812corn
cors66656442cors
cory96941512cory
cos510270392c_os
cot510483222c_ot
cowl97530812c_owl
cows97046642c_ows
cowy126427362c_owy
cox1210346782c_ox
coy810557552c_oy
coz149345362c_oz
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
crawl104916712crawl
craws105723122craws
cred76530882cred
crews105917492crews
crib86323582crib
cris66233432cris
crit65743712crit
croak115216632croak
croci95818132croci
crock135921992crock
crocs95722432crocs
croft105622682croft
crone75231332crone
crony105918672crony
crook115217572crook
croon75522782croon
crops96125232crops
crore74922862crore
cross75124502cross
croup95616782croup
crowds124910762crowds
crowdy15467172crowdy
crowed124717292crowed
crower114117552crower
crowns115615112crowns
croze164719452croze
cru57129562cr_u
crud75219612crud
cruor7310442cruor
crus65828482crus
crux135415002crux
cry89726242cr_y
dhow116614002dhow
dow76749972_dow
draw85623012draw
drew86221672drew
drop75324402drop
drown95515822drown
enow77819872enow
eros45238452eros
escrow1135912escrow
flow105924922flow
fro65530642fro_
froe75329992froe
frog85624362frog
from96923922from
frown115415972frown
frows116623102frows
glow85222522glow
grew85620262grew
grog65923342grog
grok95819682grok
grot55942052grot
growl96115822growl
grown95317352grown
grows95523922grows
how97252432_how
iron46728462iron
jow137639302_jow
know116115842know
low66051872_low
meow95117882meow
mow86650352_mow
now65950192_now
ow58950172__ow
plow95923232plow
pow87147282_pow
pro55837262pro_
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631702prom
prop85932812prop
pros65742782pros
prowl105615122prowl
prows106327012prows
raw67252252_raw
rob56754302_rob
roc520243252_roc
rod47953892_rod
roe36861072_roe
rom59855632_rom
rot37282952_rot
rows75941752_rows
scow96021422scow
screw109318532screw
scrod85115062scrod
serow86720442serow
show106229192show
slow77729492slow
snow76324792snow
sow66554762_sow
stow77325742stow
strow88920572strow
throw118719732throw
tow610557362_tow
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trows88826182trows
troy77429682troy
vow96136312_vow
vrouw11507342vrouw
vrows116115262vrows
wow96643472_wow
yow96945292_yow

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 Filter178691298720.0762351197.4
2DLD Change Limit298721940.98630296.1
3Display Results1941940.0464217.4
 (SQL Overall)1786911941.108161273.5
 
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.