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

187 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
crew9612267(None) 
brew95023561brew
chew126622131chew
clew95520571clew
craw97725261craw
cred76530881cred
crews105917491crews
crow96428131crow
drew86221671drew
grew85620261grew
screw109318531screw
acre67330772acre_
acred87126352acred
acres76327762acres
anew76623132anew
are37874572are_
area45843392area
ares45871022ares
blew94722432blew
braw94829562braw
bred75130972bred
bree67241262bree
bren65629562bren
brews105617072brews
brow97228442brow
care66968372care_
cared86050092cared
carer74942332carer
cares77369182cares
caret75360562caret
carex144822302carex
caw86647932c_aw
cee55952702c_ee
cees65941592cees
cel56040552c_el
cep75736332c_ep
cere66741472cere
cered85227442cered
ceres75540012ceres
cero66329452cero
chaw126224632chaw
chef125125622chef
chews135418512chews
chewy165011902chewy
chez184519022chez
chow125820992chow
cire65836372cire_
cires74932912cires
claw95624342claw
clef97028182clef
clews105516332clews
coed77140542coed
core67263112core_
cored85044222cored
corer75538872corer
cores76361852cores
cow89856712c_ow
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
crawl104916712crawl
craws105723122craws
creak115418432creak
cream95721342cream
credo84815562credo
creds85418772creds
creed85727392creed
creek114917392creek
creel75121482creel
creep95218102creep
creme94319322creme
crepe95520722crepe
crept95125892crept
crepy124812702crepy
cress75022832cress
crest74632692crest
crewed125316552crewed
crewel114310472crewel
crib86323582crib
cried84624282cried
crier74724462crier
cries75438402cries
cris66233432cris
crit65743712crit
croc85723732croc
crop87628632crop
crowd115815622crowd
crown105620082crown
crows105727312crows
cru57129562cr_u
crud75219612crud
cruel74815902cruel
cruet74831842cruet
crus65828482crus
crux135415002crux
cry89726242cr_y
cue57544182cue_
cued76329562cued
cues65438982cues
cure66149122cure_
cured85932132cured
curer75030752curer
cures75645432cures
curet75447642curet
curfew14426742curfew
curlew114010902curlew
dew77139922_dew
draw85623012draw
dree56638322dree
dreg66821652dreg
drek96321092drek
ere36352772ere_
few95436962_few
flew105824252flew
free75940182free
fret75845042fret
frow106425052frow
gree56641562gree
grey85624042grey
grow86127302grow
hew97642722_hew
ire36943172ire_
ired55131872ired
ires45639282ires
jew135129082_jew
knew115912122knew
krewe1238192krewe
mew86137732_mew
new66237092_new
ocrea73311822ocrea
ore36661832ore_
ores46056682ores
pew86442302_pew
phew128417112phew
plew97222812plew
pree67044732pree
prep86427672prep
prex135722972prex
prey96228482prey
prez156126312prez
prow97030382prow
raw67252252_raw
re26153742_re_
reb55844962_reb
rec55645462_rec
red46755802_red
ree37974072_ree
ref66053292_ref
reg46146492_reg
rei35647252_rei
rem56150042_rem
rep55847802_rep
res35565042_res
ret35982832_ret
rev65336622_rev
rex105740992_rex
row67453672_row
scree720031702scree
screws115513882screws
screwy14659452screwy
sew66247262_sew
shew108030762shew
shrew119720162shrew
skew116218762skew
slew76228232slew
smew95017732smew
spew95421872spew
stew77525462stew
strew89220652strew
tew66640152_tew
thew108226232thew
threw1117315712threw
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trews86118892trews
trey77228792trey
trow78031422trow
urea46528052urea
view105917672view
vrow105817472vrow
whew137618782whew
wren78221682wren
yew96436292_yew

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 Limit298721871.15625840.8
3Display Results1871870.1101700.0
 (SQL Overall)1786911871.342133152.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.