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

190 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
rugosa73456(None) 
rugola736291rugola
rugosas844971rugosas
rugose737281rugose
arugola844352arugola
erugos7347342erugos_
mucosa10166272mucosa
ruga56121232rug__a
rugolas836372rugolas
rugous739642rugous
rugs56033682rug_s_
aerugos834923aerugos_
aftosa996573aftosa
agora6914333_agora
angora71111573angora
argosy1036423argosy
arugolas944403arugolas
arugula843913arugula
august739203august
aurora6411763aurora
autos56523323autos_
bigos85020013bigos_
brughs12509063brughs_
bugloss1035893bugloss
bugout9311863bugout
bugs76035913bug_s_
bugsha1233823bugsha
bursa74921523bu_rsa
cupola10317693cupola
curiosa9346643curiosa
dagoba1074943dagoba
dagos76419443dagos_
drugs75214653drug_s_
dugong934373dugong
dugout8310363dugout
dugs614832283dug_s_
duos56728133du_os_
duros65422693duros_
egos55821653_egos_
erugo6369853erugo__
euros54920243euros_
frugs96114283frug_s_
fucose11167683fucose
fugios1037583fugios_
fugs85730693fug_s_
fugus95914013fugus_
goa47343803__go_a
goas55239943__goas
gogos77516523gogos_
gos47155133__gos_
gosh86123423__gosh
gregos847533gregos_
grumose1035723grumose
hugest10311763hugest
hugs86129753hug_s_
jucos144111713jucos_
judoka18102583judoka
judos134711733judos_
juga126417323jug__a
jugs125525603jug_s_
jugula1434983jugula
kudos105011253kudos_
logos67225333logos_
luges65928753luges_
lugs55233523lug_s_
mimosa1036363mimosa
mucosae11155313mucosae
mucosal11155843mucosal
mucosas11146673mucosas
mucose10149313mucose
muggs94912323muggs_
mugs76232043mug_s_
mungos94311373mungos_
ouzos143210413ouzos_
pagoda10487873pagoda
plugola1043013plugola
pugs76332773pug_s_
quota145111963qu_ota
raga55930813rag__a
ragas65326063ragas_
rages64539443rages_
raggs75216473raggs_
ragis66325603ragis_
ragout7317183ragout
rags55448373rag_s_
ramona8412413ramona
ramose8314403ramose
ratos55528763ratos_
redos65126763redos_
redowa1038453redowa
reges65628783reges_
regina75317143regina
regloss8218023regloss
regma84612333reg_ma
regna64614813reg_na
regosol844883regosol
regs55436573reg_s_
remora8414583remora
repos74725793repos_
reposal939113reposal
repose84121413repose
rerose63320843rerose
rhos76319063r_hos_
ribose839893ribose
rigor62714053rigo_r
rigors72813713rigors
rigour7258023rigour
rigs55137593rig_s_
rimose8310593rimose
rioja1236303r_ioja
ripost83615003ripost
roose56127093r_oose
roost55730933r_oost
rose46148903r__ose
rosy76024873r__osy
rota45834343r__ota
rotos56027883rotos_
rouges76022383rouges_
roughs105416213roughs_
ruana5312423ru_ana
ruanas6311263ruanas
rubeola9115123rubeola
rubes74928413rubes_
rubigos1033643rubigos_
ruboff1435193ruboff
rubout8313553rubout
rubs66133493ru_bs_
rubus76415053rubus_
rucks114422053rucks_
rudds74811703rudds_
rudest74016313rudest
ruers515019413ruers_
rues46044483ru_es_
ruffs114516743ruffs_
rufous948263rufous
rug46039153rug___
rugae65114763rug_ae
rugal65916093rug_al
rugate75813813rugate
rugby11448133rug_by
rugged94215373rugged
rugger84414513rugger
rugosely1242333rugosely
rugosity1243733rugosity
rugulose942893rugulose
ruins55822033ruins_
rules55234253rules_
rumba93612513ru_mba
rumbas102512013rumbas
rumina83412483rumina
rumor71011323rumo_r
rumors81110393rumors
rumour8127373rumour
rumps95922293rumps_
rums64833473ru_ms_
runes55530223runes_
rungs611819403rungs_
runoff1235413runoff
runout6414873runout
runs46438073ru_ns_
runts55927633runts_
ruse45938933ru__se
ruses56136583ruses_
rush76628183ru__sh
rusk85823313ru__sk
rusks95816193rusks_
rust45544913ru__st
rusts55026993rusts_
ruths85714643ruths_
ruts44541493ru_ts_
sagos66123873sagos_
samosa8510203samosa
segos64919483segos_
serosa6313023serosa
sughs95313323sughs_
sumos75720093sumos_
trigos74214173trigos_
trugs65516803trug_s_
tugs56231673tug_s_
udos56619903_udos_
ughs85410973_ughs_
urges64619913urges_
ursa44116903_u_rsa
vuggs10579133vuggs_
vughs12678743vughs_
vugs87022873vug_s_
yuga85615423yug__a
yugas95012063yugas_
zygoma2143493zygoma
zygose19455553zygose

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161905.93618988.5
3Display Results1901900.0633015.9
 (SQL Overall)1786911906.13929107.5
 
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.