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

108 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
urinary103724(None) 
trinary1039171trinary
ariary94114202ari_ary
binary11312222_binary
briary114912002bri_ary
culinary1355852culinary
friary124010092fri_ary
granary1157792granary
luminary13336652luminary
ordinary1244912ordinary
primary1437702primary
quinary1936932quinary
unary8315992u__nary
unitary1038612unitary
urinal6614122urina_l
urinals7610252urinals
urinate7315362urinate
acinar8310483acinar_
apiary113910383api_ary
aviary12338413avi_ary
briar75718153bri_ar_
briard94311293bri_ard
briars84814823bri_ars
bribery14426493bribery
briery114510773bri_ery
briner84519043briner_
briners94315633briners
briny104719663brin__y
burglary1473133burglary
bursary12397583bur_sary
canary11314693_canary
coronary1347693coronary
crinkly16387523crinkly
denary105316863_denary
diary95016973_di_ary
dinar66319893_dinar_
dinars75417563_dinars
dreary104611673dr_eary
finery124512893_finery
friar85414273fri_ar_
friarly13316213fri_arly
friars93812093fri_ars
fringy13309263frin_gy
gramary1355903gramary
grindery13255513grindery
gurnard944773gur_nard
hymnary1843033hymnary
inarm7314423__inarm
joinery17366593joinery
kinara10310373_kinara
laminary13337253laminary
laniary1068013laniary
luringly1237323luringly
marinara1046493marinara
nary76931223___nary
olivary1345163olivary
ornery938463or_nery
pinery115214293_pinery
plenary1237543plenary
primacy1635603primacy
printery13318433printery
priory114110263pri_ory
privacy1744233privacy
pupilary15104123pupilary
rindy95717393_rin_dy
ritard74812083_ritard
rivalry1354033_rivalry
rosary92810353_rosary
rotary92411303_rotary
ruinate7312833ruinate
ruiner64013643ruiner_
ruiners74213023ruiners
seminary1398093seminary
senary93716073_senary
ternary1038343ternary
tribunary1452243tribunary
trinal6516963trina_l
trinity10310843trinity
tripart9311433tripart
turbary1236383tur_bary
turnery10357423tur_nery
ulnar56013983u_lnar_
unarm7314453u__narm
unchary1537263unchary
unitard838003unitard
unsnarl7107153unsnarl
unwary1239823u_nwary
unweary1335843unweary
urare56322553ur__are
urari54619963ur__ari
urgingly1336733urgingly
urial54823023uri_a_l
urials64415193uri_als
urinaries949203urinaries
urinated9311613urinated
urinates8314133urinates
urinator847843urinator
urinators947633urinators
urine55026603urin__e
urines64724123urin_es
urinose738483urinose
urinous7310083urinous
vinery124912603_vinery
vivary1536983_vivary
winery125014283_winery
wintry12498923_wintry
wrinkly17295753wrinkly
zonary1838793_zonary

Search took 8 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.423422437.4
2DLD Change Limit1340271087.43618024.1
3Display Results1081080.0303600.0
 (SQL Overall)1786911087.88922650.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.