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

73 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
growls10471111(None) 
growl96115821growl_
growly13499171growly
grows95523921grow_s
prowls115511081prowls
bowls106121432_bowls
brawls115214332brawls
broils84114172broils
browns116415632browns
brows105425982brow_s
cowls106922212_cowls
crawls114712082crawls
crowds124910762crowds
crowns115615112crowns
crows105727312crow_s
drawls105511392drawls
drolls75312392drolls
drools74412812drools
drowns105612332drowns
fowls115518892_fowls
frowns126011392frowns
frows116623102frow_s
gaols66717572gao_ls
ghouls1036042ghouls
glows95518032glow_s
goals65521292g_oals
gorals76917652gorals
gowds105814042g_owds
gowks136011952g_owks
gowns95115102g_owns
graals74112912graals
grails77518782grails
grills74314802grills
groans74815062groans
groats74816652groats
grogs76319412gro_gs
groins73917202groins
groks105716122gro_ks
grooms94512522grooms
gropes95220402gropes
gross65421692gro_ss
grots65025852gro_ts
groups94210512groups
grouts75015612grouts
grovels11427812grovels
groves104318102groves
grow86127302grow__
grower104614932grower
growers113612722growers
growled12278162growled
growler11318972growler
growlers12327092growlers
grown95317352grow_n
growth1377382growth
growths1494422growths
gruels73910152gruels
howls116219222_howls
jowls156214522_jowls
owls76022932__owls
prowl105615122prowl_
prows106327012prow_s
roils54826792_roils
rolls55326232_rolls
rotls55620162_rotls
rowels94515452_rowels
rows75941752_row_s
scowls11549592scowls
trawls94412392trawls
trolls64613942trolls
trowels10358362trowels
trows88826182trow_s
vrows116115262vrow_s
yowls115715432_yowls

Search took 3 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.1231452772.4
2DLD Change Limit82551732.56332208.7
3Display Results73730.0164562.5
 (SQL Overall)178691732.70266132.9
 
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.