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

130 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
grushie113581(None) 
brushier13306972brushier
grumphie1642762grumphie
guruship1443262guruship
gushier113110072g_ushier
gussie72910152g_ussie
rushee93818772_rushee
rushier103411972_rushier
tushie939722_tushie
arshin9312173ar_shin
banshie12129543banshie
bolshie1247123bolshie
brashier13389933brashier
brassie93411523brassie
brulyie1242523brulyie
brulzie1842883brulzie
brush105917473brush__
brushed133811213brushed
brusher123813003brusher
brushes124014663brushes
brushfire1741903brushfire
brushiest14297543brushiest
brushing14359963brushing
brushup1443513brushup
brushy14468263brush_y
brusque1843703brusque
bushier123712813_bushier
couthie121810543couthie
crummie1336153crummie
crusade1036053crusade
cruse75726103crus__e
crush106815993crush__
crushed134111963crushed
crusher124412323crusher
crushes124215133crushes
crushing143010053crushing
crustier10259533crustier
cushier123610833_cushier
druggie10134073druggie
druse64817663drus__e
gauche1238553gauch_e
gawsie1038463gaws_ie
glassie8329493glassie
gobshite1443273gobshite
godship1445083godship
grannie8310353grannie
graphic1537353graphic
graphite1447153graphite
grassier9349283grassier
greenie8310123greenie
gremmie1264383gremmie
griskin1236013griskin
grislier935793grislier
gristle8169223gristle
grosze16457733gros_ze
grouchier1543843grouchier
groupie1045783groupie
grouse74315023grous__e
grubbier13344753grubbier
grudge9388583gru_dge
grue55825713gru___e
gruesome1144283gruesome
gruffier1544703gruffier
grumble12349233grumble
grume86218163gru__me
grumose1035723grumose
grumphies1743653grumphies
grumpier1334803grumpier
grunge8359583gru_nge
grungier1034983grungier
gruntle8257053gruntle
gruyere1133123gruyere
gumshoe1343663gumshoe
gunship1345383gunship
gursh94512333gursh__
gurshes112210033gurshes
guruships1542983guruships
gush85424003g_ush__
gushed114816243g_ushed
gusher104115773g_usher
gushes104719033g_ushes
gushiest123510983g_ushiest
gushily14257823g_ushily
gushing124014223g_ushing
gushy125213123g_ush_y
gussied9267193g_ussied
gussies82813303g_ussies
gustier83813863g_ustier
mashie11315933_mashie
mushier123813583_mushier
muskie123412533_muskie
plushier1375193plushier
poussie936623poussie
preship1439793preship
prossie91812953prossie
prostie91617743prostie
prussic1144743prussic
pushier123611093_pushier
reshine102816943_reshine
reship11310673_reship
reshoe92816483_reshoe
rishi8311253_rishi_
rishis9312453_rishis
roshi8310753_roshi_
roshis9311793_roshis
ruche104216763_ruch_e
ruse45938933_rus__e
rush76628183_rush__
rushed104419863_rushed
rushees103311953_rushees
rusher94019653_rusher
rushes94724363_rushes
rushiest113312923_rushiest
rushing113817703_rushing
rushlike1534333_rushlike
rushy115414813_rush_y
rusine63916593_rusine
rustic8712673_rustic
rustier74416363_rustier
rustle63615413_rustle
slushier1135983slushier
sushi8310493_sushi_
sushis9311183_sushis
toughie1187593toughie
trashier113210093trashier
trustee73514443trustee
trustier8268683trustier
trusties82712853trusties
tushies10312163_tushies
urushiol1141883urushiol

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.1561145455.1
2DLD Change Limit1340271306.17321711.8
3Display Results1301300.0462826.1
 (SQL Overall)1786911306.37528030.0
 
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.