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

135 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
upkeep143414(None) 
upkeeps1532191upkeeps
keep106329812__keep
outkeep1345672outkeep
peep85833692_p_eep
upheap13105212upheap
upleap10106842upleap
upstep1035502upstep
upsweep1442572upsweep
ackee115825363ackee_
ackees124914573ackees
akee85936813_akee_
akees96119243_akees
apeek114711873ap_eek
asleep847283asleep
barkeep1536363barkeep
beep85931213__beep
beweep13147253beweep
bleep95013453_bleep
bopeep1236763bopeep
buckeen1536703buckeen
bupkes144811483bupk_es
cheep125416503_cheep
creep95218103_creep
deep76031883__deep
epee64628503ep_ee_
epees75219833ep_ees
fakeer13378743fakeer
hakeem15407383hakeem
jeep135624843__jeep
keef115829993__keef
keek75624963__keek
keel85729463__keel
keen84830403__keen
keeps116020283__keeps
keet85347333__keet
kelep116014553__kelep
kelp105322803__kelp
kemp126418763__kemp
kep96437203__k_ep
kreep114610413_kreep
makeup1434863makeup
miskeep1536403miskeep
neep65728313__neep
outkeeps1443583outkeeps
outweep1236673outweep
pee56066513_p_ee_
peed76239183_p_eed
peek106031433_p_eek
peel65535613_p_eel
peen65938083_p_een
peeps95822363_p_eeps
peer66238353_p_eer
pees65257373_p_ees
peke105926203_peke_
pekes114623563_pekes
pep76447083_p__ep
perp89029893_p_erp
pree67044733_pree_
preed85128113_preed
preen75925053_preen
prees75937173_prees
preop94715873_preop
prep86427673_p_rep
puke105025463puk_e_
puked124716223puk_ed
pukes114523023puk_es
puree74632843puree_
pureed95017803pureed
purees84721683purees
rakee96031173rakee_
rakees104516973rakees
rupee7321283rup_ee_
rupees8312573rup_ees
seep66540343__seep
sheep105321523_sheep
skee85431473_skee_
skeed105018983_skeed
skeen94817403_skeen
skees95023123_skees
skeet95429183_skeet
skelp114211423_skelp
skep105219353_sk_ep
sleep74920183_sleep
speed85526623sp_eed
speel74420763sp_eel
speer74623903sp_eer
spleen8310263spleen
spree74830863spree_
sprees85620643sprees
steep76020703_steep
sweep104715723_sweep
takeup1234583takeup
threep115910113threep
uke75727293u_k_e_
ukes86122813u_k_es
umpteen1143843umpteen
undee65327273undee_
unkempt1544763unkempt
unkend11309223unkend
unkent103116053unkent
unkept123710873unkept
unmeet83815743unmeet
unreel63612933unreel
unseen62012623unseen
unstep839223unstep
upases84112903upases
upbear1096493upbear
upbeat10911513upbeat
upbye1244793upbye_
upend85011043up_end
upgrew1233653upgrew
upheaps1494233upheaps
upheld12115563upheld
upleaps1185233upleaps
upleapt11116863upleapt
upped103715163up_ped
upper93714263up_per
uppers102912283uppers
upprop944093upprop
uprear8168793uprear
upsend9356883upsend
upsent83314063upsent
upset73222593up_set
upsets8409683upsets
upsteps1133743upsteps
upsweeps1541773upsweeps
upswept1443473upswept
uptear896783uptear
uptempo1342413uptempo
upwell11285793upwell
vakeel1335193vakeel
veep95325093__veep
weep95131653__weep
wheep136214353_wheep

Search took 6 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.1401276364.3
2DLD Change Limit1127161355.37620966.5
3Display Results1351350.0462934.8
 (SQL Overall)1786911355.56232127.1
 
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.