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

176 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
urine5502659(None) 
brine75132271brine
murine84220021murine
purine85321891purine
trine54734601trine
urines64724121urines
ursine64114121ursine
aline57243152aline
amine75835372amine
arene55329412arene
arise56436432arise
arsine64021042arsine
azine146721412azine
bine66650852_bine
bribe94820772bribe
bride86425532bride
brie65837902bri_e
brin67038192brin_
brined95118412brined
briner84519042briner
brines85028852brines
bring85528502bring
brink116122002brink
brins75533972brins
briny104719662briny
burin75626062burin_
burins84221892burins
burnie83715412burnie
chine105231722chine
cine66242942_cine
cline76428532cline
crane75331602crane
crime94822692crime
cringe93515482cringe
cripe95521142cripe
crone75231332crone
curiae84518372curiae
curie74533032curi_e
curing94824782curing
curite85222942curite
dine55555332_dine
dourine8311442dourine
drink106816382drink
drive95318002drive
drone65324982drone
during84419402during
dwine95616142dwine
ermine8416922ermine
erne46727422er_ne
exine125518492exine
ferine96422582ferine
fine75147952_fine
fringe104013952fringe
frise85322452frise
furane94015492furane
gride75223582gride
grime85021322grime
grin55733722grin_
grind75917562grind
grins65427222grins
gripe84622962gripe
gwine95513662gwine
imine75821042imine
iring66025412iring
irone55126362irone
kine85643422_kine
koine9516482koine
krone94018732krone
larine63927042larine
line46965572_line
lupine84013532lupine
luring73820752luring
marine84230402marine
mine67256152_mine
murines93718222murines
muring95120372muring
murrine9411472murrine
mutine84420372mutine
narine63422552narine
neurine7311682neurine
nine45842172_nine
opine77422462opine
orpine83914482orpine
ourie54027292ouri_e
ovine86316642ovine
pine67755712_pine
price93725412price
pride84724732pride
prime96525602prime
prince104114762prince
prink114719672prink
print74837462print
prise74632612prise
prize164718942prize
prone75332622prone
prune75119632prune
purin75527592purin_
purines94420762purines
purins83722652purins
purline93516532purline
rice64942912_rice
ride55945122_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
rin36663182_rin_
rind56535602_rind
ring56541152_ring
rink87736992_rink
rins46153192_rins
rinse54820972_rinse
ripe66038922_ripe
rise45945232_rise
rite45849452_rite
rive75537722_rive
ruin47430512ruin_
ruined74813322ruined
ruiner64013642ruiner
ruing67221052ruing
ruins55822032ruins
rune45236292_rune
rusine63916592rusine
seine55732872seine
serine65432672serine
shine85533092shine
shrine94920052shrine
sine46560622_sine
spine76534422spine
supine84216692supine
swine85625302swine
taurine7311362taurine
thine85026852thine
tine45855132_tine
tribe74420262tribe
trice75127492trice
triene64316382triene
trike95320162trike
trined74920712trined
trines64132562trines
tripe75425382tripe
trite54730032trite
triune64210182triune
trone55131862trone
turbine9310302turbine
turdine8310272turdine
twine85822362twine
undine7817262undine
unite54828382unite
unripe82012092unripe
uprise82313692uprise
urare56322552urare
urase54624682urase
urate55432162urate
urbane82211382urbane
ureide7310362ureide
urge54722412ur_ge
urging83413122urging
urial54823022urial
uric63624932uri_c
uridine81311212uridine
urinal6614122urinal
urinate7315362urinate
urinose738482urinose
urn35731462ur_n_
urns46323892ur_ns
urping93914052urping
ursae55214452ursae
using66317962using
uterine7315192uterine
utile54718932utile
vine75643682_vine
whine116022812whine
wine74953422_wine
wring95920712wring
write85522832write
zine137036152_zine

Search took 4 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 Filter178691538000.0931921408.6
2DLD Change Limit538001762.53321239.6
3Display Results1761760.0931892.5
 (SQL Overall)1786911762.71965719.4
 
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.