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

173 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
roose5612709(None) 
goose65925901goose
loose56627681loose
moose76327191moose
noose55624061noose
roosed75621591roosed
rooser63921881rooser
rooses65526231rooses
roost55730931roost
rose46148901r_ose
rouse56634701rouse
ariose64818722ariose
arkose104911342arkose
arose55832082arose
arouse65019982arouse
boos67955032boos_
boost75132472boost
booze164718912booze
bouse75931852bouse
bowse105420632bowse
broos75126412broos_
brose75227032brose
browse115713852browse
choose115116142choose
chose105925402chose
close76425222close
comose105016842comose
cooee74531022cooee
coos67456492coos_
copse95623922copse
corse75036182corse
crosse85216302crosse
crouse84619362crouse
dose56442432_dose
douse66329722douse
dowse96020812dowse
drowse105010552drowse
erose55727272erose
fosse86119462fosse
goos57644912goos_
goosed86817032goosed
gooses75723052gooses
goosey105913512goosey
goosy96018882goosy
gorse65926812gorse
groove10438872groove
grouse74315022grouse
hoise85224772hoise
horse86132652horse
hose76547242_hose
house89131422house
jocose1537102jocose
looie55624242looie
loos49051122loos_
loosed75520892loosed
loosen66615962loosen
looser65219942looser
looses67328242looses
lose45144582_lose
louse56131012louse
lowse87219902lowse
moos66051302moos_
morose85116242morose
morse76032702morse
mouse77133002mouse
nodose738882nodose
noise55723732noise
noosed75018012noosed
nooser65517822nooser
nooses65623642nooses
nose46739362_nose
ooze136420602_ooze
ose38147342__ose
owse76321622_owse
poise75127892poise
poos65949112poos_
poove104514302poove
porose84818742porose
pose66441732_pose
posse74722272posse
propose112714842propose
prose75835122prose
raise54828052raise
ramose8314402ramose
rase46149982r_ase
repose84121412repose
rerose63320842rerose
reuse56025362reuse
rhos76319062rhos_
ribose839892ribose
rimose8310592rimose
rinse54820972rinse
rise45945232r_ise
roast56230142roast
robe65335642r_obe
robes75133302robes
roble75223022roble
robs65837872robs_
rocs65533662rocs_
rode55844302r_ode
rodes614039082rodes
rods56442062rods_
roe36861072r_o_e
roes45954132roes_
rogue66417532rogue
role45851822r_ole
roles56747982roles
roms67038962roms_
rood56733002roo_d
roods65125282roods
roof75738832roo_f
roofed105214742roofed
roofer94415282roofer
roofie93411172roofie
roofs85321152roofs
rook85532032roo_k
rooked114918142rooked
rookie103613262rookie
rooks95325042rooks
rooky126117622rooky
room66235082roo_m
roomed95218542roomed
roomer84718632roomer
roomie83013872roomie
rooms75324682rooms
roomy107118062roomy
roosers74217872roosers
roosted83211882roosted
rooster74415172rooster
roosts64916322roosts
root45655922roo_t
rooted75424002rooted
rooter64926032rooter
rootle63214452rootle
roots55933672roots
rooty86423022rooty
rope65542912r_ope
ropes75940062ropes
roque144812132roque
rosed65930342r_osed
roses56445772r_oses
roset55945242r_oset
rosy76024872r_osy
rote46249022r_ote
rotes56143902rotes
rotos56027882rotos_
rots46454092rots_
rotte54625932rotte
roue45941742r_oue
roues56039352roues
rouge65423442rouge
roused75426442roused
rouser65224082rouser
rouses65436282rouses
roust55532062roust
route55132072route
rove75136982r_ove
roves84834482roves
rows75941752rows_
rugose737282rugose
ruse45938932r_use
souse56530772souse
those85218142those
torose64317692torose
torse55833332torse
touse55430672touse
triose64715382triose
whose114914532whose
woos76238802woos_
woosh113710732woosh
worse86525262worse
youse85322232youse
zoos135828802zoos_

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.186960704.3
2DLD Change Limit538001732.72019779.4
3Display Results1731730.0463760.9
 (SQL Overall)1786911732.95260532.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.