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

102 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
upkeeps153219(None) 
upkeep1434141upkeep_
keeps116020282__keeps
outkeeps1443582outkeeps
peeps95822362_p_eeps
upheaps1494232upheaps
upleaps1185232upleaps
upsteps1133742upsteps
upsweeps1541772upsweeps
ackees124914583ackee_s
akees96119243_akee_s
barkeeps1634143barkeeps
beeps95320973__beeps
beweeps1494563beweeps
bleeps10499103_bleeps
bopeeps1333103bopeeps
buckeens1634853buckeens
bupkes144811483bupk_e_s
cheeps135312913_cheeps
creeps104213623_creeps
deeps84921773__deeps
epees75219833ep_ee_s
fakeers14446673fakeers
hakeems16394803hakeems
jeeps144715373__jeeps
keefs125116283__keefs
keeks84717253__keeks
keels94622413__keels
keens95721183__keens
keep106329823__keep_
keets95123483__keets
keleps12478813__keleps
kelps115116423__kelps
kemps135012523__kemps
keps106027303__k_eps
kreeps12427413_kreeps
makeups1533603makeups
miskeeps1644163miskeeps
neeps75617883__neeps
outkeep1345673outkeep_
outweeps1344013outweeps
peeks115021113_p_eeks
peels75226423_p_eels
peens76428193_p_eens
peep85833693_p_eep_
peers75130273_p_eers
pees65257373_p_ee_s
pekes114623563_peke_s
peps85134513_p__eps
perps95521483_p_erps
preens85020113_preens
prees75937173_pree_s
preops104911943_preops
preps96220693_p_reps
pukes114523023puk_e_s
purees84721683puree_s
rakees104516973rakee_s
rupees8312573rup_ee_s
seeps74828753__seeps
skeens103912913_skeens
skees95023123_skee_s
skeets104513253_skeets
skelps12407923_skelps
skeps115614253_sk_eps
sleeps83913323_sleeps
speeds94316053sp_eeds
speels85116393sp_eels
speers85019953sp_eers
spleens937103spleens
sprees85620643spree_s
steeps85215193_steeps
sweeps114110513_sweeps
takeups1333403takeups
threeps12687043threeps
ukes86122813u_k_e_s
unkempt1544763unkempt
unkept123710873unk_ept
unreels7258313unreels
unsteps936213unsteps
upases84112903upase_s
upbears1195423upbears
upbeats1195733upbeats
upends9438763up_ends
upheap13105213upheap_
upleap10106843upleap_
upleapt11116863upleapt
uppers102912293up_pers
upprops1044223upprops
uprears9107493uprears
upsends10265293upsends
upsets8409683up_sets
upstep1035503upstep_
upsweep1442573upsweep_
upswept1443473upswept
uptears9106453uptears
uptempo1342413uptempo
uptempos1441923uptempos
upwells12244303upwells
vakeels14113733vakeels
veeps104715723__veeps
weeps104120563__weeps
wheeps14439953_wheeps

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.406440125.6
2DLD Change Limit1340271026.47020715.1
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.90625874.7
 
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.