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

89 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
groans7481506(None) 
grans64832541gr_ans
groan65618421groan_
groats74816651groats
groins73917201groins
roans54926441_roans
begroans1145502begroans
brans75437432br_ans
broads94515142broads
brogans1049662brogans
browns116415632browns
croaks125812982croaks
croons85418422croons
crowns115615112crowns
drowns105612332drowns
frons86124042fro_ns
frowns126011392frowns
germans1079462germans
girons75014372giro_ns
glans65125832g_lans
gleans75014742gleans
gloams95210662gloams
gloats74515422gloats
goads77022852g_oads
goals65521292g_oals
goas55239942g_oa_s
goats65527302g_oats
gobans94412042gobans
goons65326772g_oons
gorals76917652gorals
gowans105512292gowans
gowns95115102g_owns
graals74112912graals
grabs85719692gr_abs
grads75625752gr_ads
grains74223092grains
grams85327312gr_ams
gran56335012gr_an_
grana65722092gr_ana
grand75122692gr_and
grands84218242gr_ands
grant64840022gr_ant
grants73722472gr_ants
grass66125202gr_ass
grays95621332gr_ays
greats76318392greats
greens75716872greens
grins65427222gr_ins
groaned9259972groaned
groaner82510132groaner
groaners9248492groaners
groat65531972groa_t
grogs76319412gro_gs
groin65521082groin_
groks105716122gro_ks
grooms94512522grooms
gropes95220402gropes
gross65421692gro_ss
grots65025852gro_ts
ground82310272ground
grounds9228302grounds
groups94210512groups
grouts75015612grouts
groves104318102groves
growls104711112growls
grown95317352grown_
grows95523922gro_ws
groyne1037212groyne
groynes1137822groynes
guans64419442g_uans
gyrons105511222gyro_ns
irons55324132iro_ns
koans95818622_koans
kroons103711242kroons
loans56026462_loans
lorans65117602lorans
moans74624362_moans
organs7912912organs
proas75028802proa_s
prolans9314272prolans
roads66523612_roads
roams74919612_roams
roan47234202_roan_
roars55622232_roars
romans84620242_romans
rowans95715342_rowans
trans54933042tr_ans
troaks104410592troaks
tronas63816892tronas

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.1231452772.4
2DLD Change Limit82551893.03027244.6
3Display Results89890.0461934.8
 (SQL Overall)178691893.19955858.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.