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

180 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
escrows123580(None) 
escrow1135911escrow_
bestrows1337042bestrows
crows105727312__crows
eschews1534552eschews
escorts9418402escorts
escots84211742esc_ots
escrowed1434652escrowed
estrous7712532estrous
scows106617802_sc_ows
screws115513882_screws
scrods94111602_scrods
serows96016392_serows
strows96718272_strows
across8312643_across
arrows92813483_arrows
ascots85312513asc_ots
barrows123411683barrows
becrowd1555173becrowd
becrowds1683773becrowds
beshrews1643163beshrews
besnows1245153bes_nows
bestows1248863bes_tows
bestrews1335603bestrews
bestrow1237243bestrow_
bestrown1345193bestrown
bicrons113410473bicrons
borrows12349253borrows
brows105425983__brows
burrows12399093burrows
chows135618203__chows
cows97046643__c_ows
craws105723123__craws
crews105917493__crews
crocs95722433__crocs
crops96125233__crops
cross75124503__cross
crow96428133__crow_
crowd115815623__crowd
crowds124910763__crowds
crown105620083__crown
crowns115615113__crowns
dacrons103211033dacrons
decrown13206053decrown
decrowns14265063decrowns
descries11311923descries
desirous947783desirous
destroys1236693destroys
discrown1445283discrown
discrowns1544663discrowns
echoes114715523e_choes
echos105216463e_cho_s
ecrus75113863e_cr_us
elbows1196713e_lbows
embows1396823e_mbows
embrown1454793embrown
embrowns1544043embrowns
emerods10137653emerods
encores9315213encores
endows104610423e_ndows
engross837123engross
enows85115493e__nows
enrols61213383e_nrols
enscroll1093333enscroll
enscrolls1192523enscrolls
eros45238453e__ro_s
errors63311313e_rrors
escalops1244673escalops
escapes113811673escapes
escargots1262263escargots
escarole1045743escarole
escaroles1145273escaroles
escarps11397373escarps
escars83913133esc_ars
eschars1237173eschars
eschew1436333eschew_
escort84616483esc_ort
escot75320083esc_o_t
escrowing1544813escrowing
escudos1043493escudos
esprits938393esprits
estops84011223es_tops
estrays10529403estrays
estrins7315853estrins
estriols856253estriols
estrone7413953estrone
estrones8313323estrones
estrums9208603estrums
estrus61912113estr_us
euros54920243e_uro_s
eyebrows1642453eyebrows
farrows13259783farrows
fencerows1742243fencerows
frows116623103__frows
furrows13327793furrows
grows95523923__grows
harrows132611033harrows
incross937663incross
macrons113514893macrons
macros104017013macro_s
marrows122911823marrows
microns113814783microns
micros104115363micro_s
misgrows1444963misgrows
morrows12318723morrows
narrows10258843narrows
oestrous869923oestrous
outcrows1346653outcrows
outrows10311403outrows
prows106327013__prows
recross989833recross
recrown12257573recrown
recrowns13246143recrowns
regrows11269153regrows
rescores105415693rescores
reshows132510453res_hows
resows93915353res__ows
rows75941753___rows
sarods74918573_sarods
saros55238063_saro_s
schrods1337433_schrods
scions82612243_scions
scoops105414363_scoops
scoots85315943_scoots
scops95820193_sc_ops
scores84725923_scores
scorns85713023_scorns
scots74025913_sc_ots
scow96021423_sc_ow_
scowl1012012973_sc_owl
scowls11549593_sc_owls
scrags95713803_scrags
scrams105216623_scrams
scraps106017243_scraps
scrawl11208083_scrawl
scrawls12177273_scrawls
screes85023963_screes
screw109318533_screw_
screwy14659453_screwy
scries85226823_scries
scrims104615933_scrims
scrips105316033_scrips
scrod85115063_scro_d
scroll8310163_scroll
scrolls938063_scrolls
scroop10299773_scroop
scroops11288243_scroops
scrota8310193_scrota
scrubs104210313_scrubs
scrums104614253_scrums
seccos1039923secco_s
secrets9311773secrets
sectors93116443sectors
serous65023563_serous
serow86720443_serow_
setscrews1441443setscrews
shows115324583_s_hows
shrews129313913_shrews
slows85323463_s_lows
snows84719893_s_nows
sorrows10278403sorrows
sows75342493_s__ows
stows86622703_s_tows
straws98718673_straws
strews96817093_strews
strops86220383_strops
strow88920573_strow_
strown96812093_strown
stroys95914603_stroys
testcross1142543testcross
throws129715233_throws
trows88826183__trows
uncross938193uncross
uncrown1236323uncrown
uncrowns1344363uncrowns
unscrews1343313unscrews
upgrows1334323upgrows
velcros1244033velcro_s
vrows116115263__vrows
yarrows13277853yarrows

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271806.62320236.6
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.84226116.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.