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

177 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
rugola73629(None) 
arugola844351arugola
rugolas836371rugolas
rugosa734561rugosa
arugolas944402arugolas
arugula843912arugula
cupola10317692cupola
jugula1434982jugula
plugola1043012plugola
rubeola9115122rubeola
ruga56121232rug__a
rugal65916092rugal_
rugosas844972rugosas
rugose737282rugose
rugous739652rugous
agora6914333_agora
angora71111573angora
areola6813673areola
argala74712673argala
argol65317263argol_
argols74514613argols
arugulas943913arugulas
aureola747033aureola
aurora6411763aurora
bola66035563__bola
bugle84721943bug_le
bugout9311863bugout
bugsha1233823bugsha
bulla74620563bu_lla
canola8313623canola
chola104718033_chola
citola838393citola
cola66541393__cola
crapola1136913crapola
cupolas11277753cupolas
cupula10328433cupula
dagoba1074943dagoba
dongola945473dongola
dugong934373dugong
dugout8310363dugout
eidola737683eidola
erugo6369853erugo__
erugos7347343erugo_s
frugal1036393frugal_
fugal95613033fugal_
fugle94915543fug_le
gala55635163__gala
gigolo836533gigolo
goa47343803__go_a
goal55829303__goal
gold65430163__gold
golf85731183__golf
granola837913granola
guggle94110433guggle
hugely1336803hugely
hula74923753hu__la
hulloa95011183hulloa
judoka18102583judoka
juga126417323jug__a
jugal135612403jugal_
juggle154310283juggle
jugular1534513jugular
kola85124963__kola
kugel1068563kugel_
kugels1146073kugels
ligula7359673ligula
lunula636173lunula
mola66035633__mola
moola75117033_moola
mucosa10166273mucosa
mughal1236273mughal
mulla74317113mu_lla
pagoda10487873pagoda
payola11208113payola
pergola1067623pergola
plugolas1143133plugolas
pula65129373pu__la
pyrola1139003pyrola
quoll14379493qu_oll
quota145111963qu_ota
radula749313radula
raga55930813rag__a
raggle83712883raggle
raglan73711503rag_lan
ragout7317183ragout
rambla103510933rambla
ramona8412413ramona
ranula6311813ranula
recoal84117973recoal
redowa1038453redowa
refold103812113refold
regal65023793regal_
regale74821453regale
regalia839223regalia
regild8149773regild
regilt71217493regilt
regina75317143regina
reglow10339403reglow
regma84612333reg_ma
regna64614813reg_na
regnal74812933regnal
regular838423regular
reguli738143reguli
remold93412973remold
remora8414583remora
repoll8410793repoll
reroll6412683reroll
resold73915363resold
resole64624183resole
retold73013753retold
revolt9316223revolt
rigor62714053rigo_r
rigors72813713rigors
rigour7258023rigour
rioja1236303r_ioja
role45851823r__ole
rolf75134873r__olf
roll46331653r__oll
roseola777053roseola
rota45834343r__ota
roughly14507293roughly
ruana5312423ru_ana
rubble104315673rubble
rubbly133710613rubbly
rubel75416833rubel_
rubella9146523rubella
rubels84112993rubels
rubeolar10153213rubeolar
rubeolas10154853rubeolas
ruble74521253ru_ble
ruboff1435203ruboff
rubout8313563rubout
ruckle124414583ruckle
ruddle83414203ruddle
rudely10389973rudely
ruffle124111673ruffle
ruffly15336673ruffly
rufous948273rufous
rug46039153rug___
rugae65114763rug_ae
rugalach1441983rugalach
rugate75813813rugate
rugby11448133rug_by
rugelach1442033rugelach
rugged94215383rugged
rugger84414513rugger
rugosely1242333rugosely
rugs56033683rug__s
rule49938423ru__le
ruly76323143ru__ly
rumba93612513ru_mba
rumble103718813rumble
rumbly134412163rumbly
rumina83412483rumina
rumor71011323rumo_r
rumors81110403rumors
rumour8127383rumour
rumple103913013rumple
rumply13348573rumply
rundle73214233rundle
runkle103611543runkle
runoff1235413runoff
runout6414873runout
rural55821173rural_
rustle63615413rustle
rutile65217683rutile
sigla64515203sig_la
sola45541863__sola
subgoal1046323subgoal
tola45236333__tola
tufoli933973tufoli
ugly86012383_ug_ly
ungula737603ungula
uvula845153_uvula
viola85915543_viola
yuga85615423yug__a
zygoma2143493zygoma

Search took 6 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 Filter1786911127160.1731032896.0
2DLD Change Limit1127161775.33021147.5
3Display Results1771770.0602950.0
 (SQL Overall)1786911775.56332121.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.