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 “arouse” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
arouse6501998(None) 
arose55832081aro_se
aroused84914341aroused
arouser74514421arouser
arouses74921291arouses
carouse9614421carouse
crouse84619361crouse
grouse74315021grouse
rouse56634701_rouse
abuse77119562a_buse
accuse103411032accuse
ahorse9311512ahorse
amuse75920832a_muse
arbute8311042arbute
arcus76918862arcus_
arcuses94814692arcuses
argue64818442argu_e
argues74516412argues
argus66716542argus_
arguses84711742arguses
ariose64818722ariose
arise56436432ar_ise
arkose104911342arkose
armure8710132armure
around72712412around
arousal748632arousal
arousers84810972arousers
arse46539272ar__se
aurous64119262aurous_
blouse84714722blouse
bouse75931852_bouse
brose75227032bro_se
browse115713852browse
caroused1149252caroused
carousel1057312carousel
carouser1068842carouser
carouses10614502carouses
chouse116017562chouse
crosse85216302crosse
croupe105114432croupe
croute84617272croute
cruse75726102cr_use
douse66329722_douse
drowse105010552drowse
druse64817662dr_use
erose55727272ero_se
groused94712832groused
grouser84513692grouser
grouses84616542grouses
house89131422_house
louse56131012_louse
mouse77133002_mouse
parous84024162parous_
profuse1237152profuse
prose75835122pro_se
rearouse839362rearouse
reuse56025362_reuse
roose56127092_roose
rose46148902_ro_se
roue45941742_rou_e
roues56039352_roues
rouge65423442_rouge
roused75426442_roused
rouser65224082_rouser
rouses65436282_rouses
roust55532062_roust
route55132072_route
ruse45938932_r_use
scouse84113632scouse
souse56530772_souse
spouse84112512spouse
touse55430672_touse
troupe84812432troupe
trouser73812462trouser
uprouse937222uprouse
youse85322232_youse

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 Filter178691825510.1731032896.0
2DLD Change Limit82551763.54623280.0
3Display Results76760.0164750.0
 (SQL Overall)178691763.73547842.3
 
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.