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

128 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
aerugo73580(None) 
aerugos834921aerugos
erugo6369851_erugo
aero45435342aer__o
ergo56420152_er_go
erugos7347342_erugos
aargh96314083aar_gh
aarrgh10786303aarrgh
abrupt1039943abrupt
aerate64830553aerate
aerator7314843aerator
aerial64625713aerial
aerie54634603aer_ie
aeried74221863aeried
aerier64823153aerier
aeries64737783aeries
aerify122810113aerify
aerily93017013aerily
aerobe8412403aerobe
aerogel836523aerogel
aerosol747683aerosol
aery77231683aer__y
ago48845523a___go
ajuga1335883a_juga
almug8429303almug_
almugs9396423almugs
amigo86515453a_migo
anergy10156863aner_gy
arco68331543a_r_co
argol65317263a_r_gol
argon65520593a_r_gon
argot67728643a_r_got
argue64818443a_rgue
argus66716543a_rgus
arroyo936963arroyo
arugola844353a_rugola
arum66129033a_ru_m
arums75517833a_rums
arvo76023433a_r_vo
aurum7614963auru_m
aurums849383aurums
ausubo853653ausubo
auto47432083a__uto
average1158853average
bedrug10164953bedrug_
bedrugs11194283bedrugs
beluga936233beluga
berg75425543ber_g_
bergs84718043ber_gs
brugh115414293_brugh
cargo85322073car_go
cero66329453cer__o
ceruse83914523ceruse
colugo935863colugo
debug94210063debug_
debugs10467823debugs
deluge8189403deluge
drug65718133_drug_
drugs75214653_drugs
ego46726053_e__go
erg45531073_er_g_
ergot65422893_er_got
ergs55523813_er_gs
eringo739553_eringo
eruct74022353_eruct
erupt74220063_erupt
eryngo1033613_eryngo
euro45325273_e_uro
farrago1144923farrago
ferula93011173ferula
ferule93413203ferule
forego1038903forego
forgo94418333for_go
frug86517103_frug_
frugs96114283_frugs
gerund836163gerund
grego7310523_grego
hereto9313693hereto
hero74635783her__o
heugh125410923he_ugh
lanugo735573lanugo
largo65319783lar_go
marengo1035263marengo
menudo945793menudo
merge84523683mer_ge
merino8315093merino
pargo86723723par_go
pengo84317593pe_ngo
perigon1039853perigon
pernio8513143pernio
peruke123210393peruke
peruse84016843peruse
refuge105312613refuge
repugn946493repugn
rerig64018483rerig_
rerigs74014793rerigs
rerun58722153reru_n
reruns66413743reruns
rug46039153__rug_
ruga56121233__ruga
rugs56033683__rugs
sargo65424413sar_go
sego56525183se__go
serge64727463ser_ge
serpigo1044833serpigo
serum75223473seru_m
serums83916303serums
servo84516683ser_vo
sevruga1142223sevruga
shrug94512513shrug_
shrugs10469163shrugs
sorgo64719723sor_go
sprug85313893sprug_
sprugs94010173sprugs
tenuto648743tenuto
teredo7310783teredo
terga63315643ter_ga
tergum937933tergum
teugh95511613te_ugh
trigo65716053_trigo
trug55720043_trug_
trugs65516803_trugs
verge93419833ver_ge
verso85314633ver_so
vertigo1146133vertigo
virago1046643virago
xerus12313333xeru_s
zero134822463zer__o

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.1401276364.3
2DLD Change Limit1127161285.43620735.1
3Display Results1281280.0462782.6
 (SQL Overall)1786911285.62231784.2
 
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.