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

204 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
uprouse93722(None) 
uprose82311481upro_se
uproused1135831uproused
uprouses1037551uprouses
arouse65019982_arouse
carouse9614422carouse
crouse84619362_crouse
cuprous1149742cuprous_
grouse74315022_grouse
profuse1237152_profuse
prose75835122_pro_se
rouse56634702__rouse
spouse84112512sp_ouse
unhouse1038922unhouse
upraise9158602upraise
uprise82313692upr_ise
uprush1135782upr_ush
appose10411993appo_se
aprons8316993aprons_
arose55832083_aro_se
aroused84914343_aroused
arouser74514423_arouser
arouses74921293_arouses
aurous64119263aurous_
blouse84714723_blouse
bouse75931853__bouse
brose75227033_bro_se
browse115713853_browse
bughouse1445073bughouse
caroused1149253caroused
carousel1057313carousel
carouser1068843carouser
carouses10614503carouses
cerous85821203cerous_
ceruse83914523cer_use
chouse116017563_chouse
crosse85216303_crosse
croupe105114433_croupe
croute84617273_croute
cruse75726103_cr_use
cupreous1255603cupreous_
delouse839833delouse
dormouse1144243dormouse
douse66329723__douse
drowse105010553_drowse
druse64817663_dr_use
erose55727273_ero_se
espouse936403espouse
funhouse1444523funhouse
groused94712833_groused
grouser84513693_grouser
grouses84616543_grouses
gyrose105310253gyro_se
house89131423__house
leprose938543lepro_se
leprous938843leprous_
louse56131013__louse
lupous849433lup_ous_
morose85116243moro_se
mouse77133003__mouse
nuthouse1145833nuthouse
operose939433opero_se
oppose1039193oppo_se
outhouse11310873outhouse
parous84024163parous_
pause75021833_p_ause
perfuse1247663perfuse
peruse84016843_peruse
pious74621273_pious_
poise75127893_p_oise
porose84818743_porose
porous84419483porous_
pose66441733_p_o_se
posse74722273_p_osse
praise84419413_praise
prase76128753_pr_ase
praus74621753_praus_
prese75228383_pr_ese
prise74632613_pr_ise
proas75028803_proas_
probe94320813_pro_be
probes104119453_probes
procure1138573_procure
prods85523553_prods_
produce1267513_produce
profs105120893_profs_
progs86624153_progs_
prole74527793_pro_le
proles84627203_proles
promise113415843_promise
proms95426403_proms_
prone75332623_pro_ne
propose112714843_propose
props95726883_props_
pros65742783_pro_s_
prosed94921093_pro_sed
proser84223463_pro_ser
proses84733473_pro_ses
proso77222413_pro_so
pross76529403_pro_ss
prosses94019513_prosses
prossie91812953_prossie
prost75434103_pro_st
prosy106319253_pro_sy
proud84615483_prou_d
prouder10310373_prouder
prove104823193_pro_ve
proves114322253_proves
prows106327013_prows_
prude84615973_pr_ude
prune75119633_pr_une
purpose1137383purpose
purpure1195993purpure
purse76028893pur__se
pursue84512253pursu_e
pursues94111373pursues
rearouse839363rearouse
rehouse10311773rehouse
rerose63320843rero_se
reroute7313963reroute
reuse56025363__reuse
roose56127093__roose
rose46148903__ro_se
roue45941743__rou_e
roues56039353__roues
rouge65423443__rouge
roused75426443__roused
rouser65224083__rouser
rouses65436283__rouses
roust55532063__roust
route55132073__route
ruse45938933__r_use
scouse84113633_scouse
scrouge1036353scrouge
serous65023563serous_
souse56530773__souse
sporule937273sporule
spoused10349653sp_oused
spouses92912813sp_ouses
sprout8419403sprou_t
sprouted1136383sprouted
sprouts949983sprouts
spruce103910873spr_uce
sprue74717633spr_u_e
sprues84515763spr_ues
sucrose939303sucro_se
suppose1137973suppo_se
taphouse1346333taphouse
torose64317693toro_se
torous64319023torous_
touse55430673__touse
troupe84812433_troupe
trouser73812463_trouser
unaroused1046523unaroused
unhorse1038583unhorse
unhoused1238153unhoused
unhouses1138703unhouses
unloose797863unloose
unrobe82611673unro_be
unrobes9269733unrobes
unrough11105233unrough
unround8138503unround
unrove92511683unro_ve
upbore10247883upbo_re
upborne11255133upborne
upbound12134813upbound
upbows1384683upbows_
upcoast1165543upcoast
upcourt1146103upcourt
updos8389513updo_s_
updove1234483updo_ve
upgrows1334323upgrows_
uphove1436133upho_ve
uphroe1136083uphro__e
uphroes1236303uphroes_
upmost1068193upmo_st
upprops1044223upprops_
upraised11167413upraised
upraiser10175843upraiser
upraises10188473upraises
uprate83916543upr_ate
uprates93814863uprates
uprisen9227353upr_isen
upriser9218763upr_iser
uprises92012733upr_ises
uproar8106933upro_ar
uproars986453uproars
uproot8314123upro_ot
uprooted1186393uprooted
uprooter1085243uprooter
uproots937143uproots
uprousing1235623uprousing
uprushed14234473upr_ushed
uprushes13194863upr_ushes
uptore8279453upto_re
uptoss836093upto_ss
uptossed1142933uptossed
uptosses1043973uptosses
urase54624683u_r_ase
urease64516993u_rease
urus46426133u_r_us_
uruses63616503u_r_uses
uveous936603uveous_
youse85322233__youse

Search took 7 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.1531167915.0
2DLD Change Limit1340272046.31321230.3
3Display Results2042040.0802550.0
 (SQL Overall)1786912046.54627297.7
 
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.