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 “replow” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

289 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
replow11421034(None) 
reflow12379651reflow
reglow10339401reglow
replot83818591replot
replows12329701replows
bellow114213352bellow
below104617192be_low
deploy1237582deploy
fellow123712742fellow
mellow114112222mellow
peplos101211542peplos
plow95923232__plow
reavow1235722reavow
reflew12389452reflew
reflown13316212reflown
reflows13258982reflows
reglows11288842reglows
regrow10309882regrow
replan83215822replan
replay113412922replay
repled93319772repled
replots93412632replots
replowed14127562replowed
reply104015852repl_y
repo66027542rep_o_
repoll8410792repoll
repos74725792rep_os
repot75132622rep_ot
repro75315912repro_
repros84216002repros
reshow123111432reshow
resow88217242re_sow
yellow12429882yellow
aglow94711963_aglow
allow85420663_allow
alow75328593__alow
barlow112911423barlow
beclog1136863beclog
beclown1435423beclown
bellows124313303bellows
belon73924113be_lon
belows114614183be_lows
besnow1145713besnow
bestow1149463bestow
billow114111223billow
blow95827193__blow
callow114714663callow
cello74919583cello_
cellos84517803cellos
celom9515683ce_lom
coplot10518273coplot
crepon1039933crep_on
declaw1266703declaw
deplore1039483deplore
deploys1336523deploys
depot85727923dep_ot
diploe9810153diploe
elbow10117703_elbow
embow1297553_embow
employ1346493employ
endow94510983_endow
enow77819873_e_now
ephod1139123_ephod
ephor10310013_ephor
epilog976463_epilog
epos66723733_ep_os
erenow937373erenow
fallow124713853fallow
felloe93513923felloe
fellows134212433fellows
felon84619293fe_lon
flow105924923__flow
follow124010353follow
glow85222523__glow
hallow124818323hallow
hello86522983hello_
hellos95321683hellos
helo75332853he_lo_
helos84928063he_los
helot85332683he_lot
hollow124212663hollow
inflow1235293inflow
jello126716273jello_
jellos134714283jellos
lepton82510793lepton
low66051873___low
mallow114014743mallow
meadow1237403meadow
mellows123812233mellows
melon73922083me_lon
meow95117883me__ow
merlon83012353merlon
merlot83217603merlot
nephew1434113nephew
pelon74423213pe_lon
pepla9312863pepl_a
peplum12156823peplum
peplus10138343peplus
pepo87622153pep_o_
pepos96620083pep_os
pillow113110573pillow
plew97222813__plew
plod76723273__plod
plop86625743__plop
plot66141233__plot
plows105419903__plows
ploy96123603__ploy
pow87147283__p_ow
prelaw1139103pre_law
preplan1149953preplan
preshow15237413preshow
prow97030383__prow
raptor83912823raptor
real45750293real__
realer63528593realer
reales64934123reales
realia6314593realia
reallot7312133reallot
really93315613really
realm75621623real_m
realms84913493realms
reals55038653real_s
realtor73611353realtor
realty92713693realty
reason62616333reason
reavows1335273reavows
rebloom1145653rebloom
rebook125213203rebook
reboot84119333reboot
rebop9313283re_bop
rechew14310213rechew
reckon123010543reckon
reclad9311873reclad
recolor978693recolor
recon75624243re_con
recook125513923recook
recrown12257573recrown
recto74520803recto_
rector84019743rector
rectos85718783rectos
redeploy1453173redeploy
redleg839263redleg
redly94217193redl_y
redo56029363re_do_
redon65424883re_don
redos65126763re_dos
redowa1038453re_dowa
redox134714233re_dox
redpoll1045043redpoll
redraw10269853redraw
redrew10309503redrew
redtop937973redtop
reel45240533reel__
reeled74725533reeled
reeler63822573reeler
reels55333263reel_s
reemploy1543343reemploy
reendow11285063reendow
reflag1098083reflag
reflet94024233reflet
reflex16359513reflex
refloat10310833refloat
reflood1136363reflood
reflowed15126903reflowed
reflower14126843reflower
reflux16315413reflux
refly113914563refl_y
refold103812113refold
region74614903region
reglet73724233reglet
regloss8218023regloss
reglowed13125853reglowed
reglue739703reglue
regrew10388563regrew
regrown11237363regrown
regrows11269153regrows
reknot10311733reknot
relax124817803re_lax
relay84424673re_lay
relet54749823re_let
relic74623363re_lic
relit55340683re_lit
reload7413893re_load
reloan6415693re_loan
relock124713523re_lock
relook104813743relook
rely75428953re_l_y
remold93412973remold
renew83917513re_new
renown9369983re_nown
renvoi945863renvoi
rep55847803rep___
repack142412163repack
repaid94716323repaid
repair84011463repair
repand95316063repand
repark123511713repark
repass84114703repass
repast83520633repast
repave114813873repave
repay104818453rep_ay
repays113813973repays
repeal84718283repeal
repeat85127213repeat
repeg84015053rep_eg
repegs93311943repegs
repel74921403rep_el
repels84318763repels
repent84728873repent
reperk122511773reperk
repin75324703rep_in
repine85627813repine
repins84924313repins
replace113214283replace
replans92814943replans
replant93318533replant
replate93420053replate
replays12399763replays
replead10399003replead
replete92912983replete
replevy1533463replevy
replica1137943replica
replicon1244323replicon
replied103914443replied
replier94214973replier
replies94521043replies
replowing1537413replowing
replumb1343393replumb
repolls939053repolls
report85326013report
repose84121413repose
repots85621003repots
repour8310993repour
repower12329883rep_ower
repp85418743rep__p
repped114616723repped
repps95114343rep_ps
reprobe112310133reprobe
reproof1238783reproof
reprove122911073reprove
reps65937953rep__s
repugn946493repugn
repulse938193repulse
repump1235683repump
repute84716093repute
reroll6412683reroll
reroof9315003reroof
resaw84117253re_saw
resew84519503re_sew
reshod103012233reshod
reshoe92816483reshoe
reshot93519633reshot
reshown13257903reshown
reshows132510453reshows
resod64720053re_sod
resold73915363resold
resole64624183resole
resown94112923re_sown
resows93915353re_sows
resplit9310373resplit
respool937633respool
respot83117633respot
retold73013753retold
retook104313443retook
retool63914483retool
retro55020953retro_
retros63820193retros
review1238693review
revolt9316223revolt
rewon86920573re_won
ripsaw1134283ripsaw
row67453673r___ow
sallow94315753sallow
sepoy10314303sep_oy
serow86720443se_row
slow77729493__slow
tallow93714203tallow
teflon937453teflon
teloi54217383te_loi
telos55424523te_los
tepoy10312163tep_oy
upbow1245613_upbow
upflow1433523upflow
wallow123913513wallow
weblog1234223weblog
willow12369693willow
yellows13329603yellows
yellowy16255693yellowy
zealot15313473zealot

Search took 7 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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162896.17018268.4
3Display Results2892890.1262293.7
 (SQL Overall)1786912896.45227695.4
 
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.