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

240 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
urp5642640(None) 
burp85028881burp
ump76130441ump
up47832821u_p
urb55731111urb
urd46427051urd
urn35731471urn
urps66920481urps
alp56641132alp
amp77541022amp
app76827602app
ar211379382ar_
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
asp57235342asp
aura45836252aura
bap76455842bap
bop77549482bop
bra56339462bra
bro56236602bro
brr56921922brr
bump106228242bump
bur55744692bur_
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burl64937182burl
burn65636432burn
burps94220172burps
burr65631232burr
burs65847422burs
bury95633592bury
cap76758982cap
carp85139812carp
cep75736332cep
cop711162372cop
crap85731842crap
crop87628632crop
cru57129562cru
cry89726242cry
cup76738242cup
cur56841982cur_
curb86732222curb
curd77634982curd
cure66149122cure
curf97538782curf
curl66035052curl
curn66731892curn
curr65429652curr
curs65645542curs
curt67051712curt
cusp86021062cusp
dap66652452dap
dip67848982dip
dorp76028052dorp
drip76223952drip
drop75324402drop
dry76526032dry
dump95927092dump
dup67637882dup
dura55232112dura
dure56341812dure
durn56127632durn
duro56228022duro
durr55624352durr
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738362ern
err35626532err
ers36046282ers
euro45325272euro
fop86743702fop
frap95925812frap
fro65530642fro
fry96226502fry
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
gap67055612gap
gip67645362gip
gorp75625902gorp
grip76127022grip
gulp75521362gulp
guru54623912guru
gyp98319012gyp
hap87360052hap
harp96134292harp
hep86644142hep
hip86750432hip
hop87554592hop
hump116228722hump
hup86437812hup
hurl76029932hurl
hurt77142572hurt
hyp117822462hyp
imp76626972imp
ire36943172ire
irk76426362irk
jump156621722jump
jura116024892jura
jury146719592jury
kep96437202kep
kip97042142kip
kop97440202kop
kuru85521802kuru
lap58565272lap
lip514755802lip
lop58255312lop
lump86531702lump
lure45142462lure
lurk86624162lurk
map77255122map
mop76950822mop
mump105425722mump
mura65633302mura
mure65941332mure
murk105527252murk
murr65225132murr
nap56753202nap
nip56945982nip
nurd56224342nurd
nurl45327242nurl
op45850162_op
or27354732or_
ora37250832ora
orb55736862orb
orc57034922orc
ore36661832ore
ors35750112ors
ort39465232ort
our36042892our_
ours47237562ours
pap76758402pap
pep76447082pep
perp89029892perp
pip78051042pip
pop76252252pop
prep86427672prep
pro55837262pro
prop85932812prop
pry85728052pry
pulp84825352pulp
pump105726852pump
pup76339882pup
pur56840552pur_
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
quip154818622quip
rap56261962rap
re26153742_re
rep55847802rep
rip56851302rip
rub56342822rub
rue35549262rue
rug46039152rug
rum56644642rum
rump86729082rump
run36244992run
rut35560522rut
sap56463232sap
sip57656012sip
slurp74014982slurp
sop57557862sop
sri35634002sri
sump86331532sump
sup57041942sup
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
tap57663872tap
tarp66936412tarp
tip56551222tip
top510560682top
trap67532802trap
trip66830392trip
trop66833302trop
try66529672try
tump85927032tump
tup56037542tup
turd56027622turd
turf75334052turf
turk86125862turk
turn46330392turn
turps74918732turps
udo49027302udo
ugh76520682ugh
uh57429852u_h
uke75727292uke
ulu36028702ulu
um47338832u_m
umm711921262umm
umps85721942umps
un28341142u_n
unrip72012862unrip
uns35936762uns
upo58925862upo
ups55629052ups
urbs65922062urbs
urds55922432urds
urea46528062urea
urge54722422urge
uric63624942uric
urns46323902urns
urped84615282urped
ursa44116912ursa
urus46426142urus
us26937432u_s
use36835162use
usurp7106902usurp
ut28647032u_t
uta37425582uta
ute35335882ute
uts35534372uts
wap86553372wap
warp95635002warp
wop87145132wop
wrap96821972wrap
wry96524702wry
yap85949822yap
yep86638962yep
yip87241182yip
yup86031702yup
yurt76435042yurt
zap145840692zap
zep147129142zep
zip146636222zip

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 Filter178691140840.500357382.0
2DLD Change Limit140842400.76618386.4
3Display Results2402400.1062264.2
 (SQL Overall)1786912401.372130241.3
 
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.