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

226 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
urb5573110(None) 
arb510448421arb
burb85334671burb
curb86732221curb
orb55736861orb
rub56342821rub
urbs65922051urbs
urd46427041urd
urn35731461urn
urp56426391urp
ab410674762_ab
alb57342652alb
ar211379382ar_
arbs66834732arbs
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
aura45836252aura
barb85240062barb
bib77045922bib
blurb95214902blurb
bob76755662bob
bra56339462bra
bro56236602bro
brr56921922brr
bub76343972bub
bulb85626692bulb
bur55744692bur_
bura66139532bura
burbs95423492burbs
burd75534262burd
burg74930362burg
burl64937182burl
burn65636422burn
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
cab78355402cab
carb85143162carb
cob710258752cob
crab85727672crab
crib86323572crib
cru57129562cru
cry89726242cry
cub76940942cub
cur56841982cur_
curbs94821652curbs
curd77634982curd
cure66149122cure
curf97538782curf
curl66035052curl
curn66731882curn
curr65429652curr
curs65645542curs
curt67051712curt
dab67455562dab
darb76033532darb
deb66342692deb
dib65746932dib
drab76226452drab
drib76823252drib
drub75920132drub
dry76526032dry
dub66642202dub
dumb97124102dumb
dura55232112dura
dure56341812dure
durn56127622durn
duro56228022duro
durr55624352durr
ebb72418622ebb
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738352ern
err35626532err
ers36046282ers
euro45325272euro
exurb1457702exurb
fab87453132fab
fib86344262fib
fob86748332fob
forb97131332forb
fro65530642fro
fry96226502fry
fub86337392fub
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
gab67155992gab
garb75332672garb
gib66443522gib
gob68950892gob
grab75427612grab
grub77220082grub
guru54623912guru
herb94730962herb
hob87550922hob
hub86437482hub
hurl76029932hurl
hurt77142572hurt
ire36943172ire
irk76426362irk
jab128444112jab
jib125835962jib
job128041772job
jura116024892jura
jury146719592jury
kab97145852kab
kerb104322712kerb
kob99442382kob
kuru85521802kuru
lab58864782lab
lib57750262lib
lob57154462lob
lure45142462lure
lurk86624162lurk
mib76946102mib
mob78651912mob
mura65633292mura
mure65941332mure
murk105527252murk
murr65225132murr
nab56954922nab
neb57238622neb
nib56745182nib
nob58954422nob
nub56439142nub
numb85520612numb
nurd56224342nurd
nurl45327242nurl
or27354732or_
ora37250832ora
orbs66626252orbs
orby97519602orby
orc57034922orc
ore36661832ore
ors35750112ors
ort39465232ort
our36042892our_
ours47237562ours
pro55837262pro
pry85728052pry
pub76037692pub
pur56840552pur_
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
re26153742_re
reb55844962reb
rib56848022rib
rob56754302rob
rube65532012rube
rubs66133492rubs
ruby97819942ruby
rue35549262rue
rug46039152rug
rum56644642rum
run36244982run
rut35560522rut
sab56563202sab
sib56850302sib
slurb74116322slurb
sob57857942sob
sorb68333042sorb
sri35634002sri
sub55445552sub
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
tab57460322tab
try66529672try
tub55640032tub
turbo71015042turbo
turd56027622turd
turf75334052turf
turk86125862turk
turn46330382turn
udo49027302udo
ugh76520682ugh
uh57429852u_h
uke75727292uke
ulu36028702ulu
um47338832u_m
umbo85516652umbo
umm711921262umm
ump76130442ump
un28341132u_n
unbe65319272unbe
uns35936752uns
up47832822u_p
upby1139062upby
upo58925862upo
ups55629052ups
urban72013862urban
urbia7311132urbia
urds55922422urds
urea46528052urea
urge54722412urge
uric63624932uric
urns46323892urns
urps66920472urps
ursa44116902ursa
urus46426132urus
us26937432u_s
use36835162use
ut28647032u_t
uta37425582uta
ute35335882ute
uts35534372uts
verb96224872verb
wab87051832wab
web85735562web
wry96524702wry
yob87945272yob
yurt76435042yurt

Search took 1 second 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.0602978183.3
2DLD Change Limit140842260.37637457.4
3Display Results2262260.0464913.0
 (SQL Overall)1786912260.482370728.2
 
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.