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

174 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
erratas73686(None) 
errata639011errata_
ergates8314492ergates
errands847602errands
errants7410642errants
erratic9311112erratic
erratics1046982erratics
erratum944502erratum
fermatas13246222fermatas
ferrates113013422ferrates
reatas64021012_reatas
riatas63915092_riatas
serrates82617022serrates
stratas73013582stratas
aerates74627493aerates
albatas938373albatas
amritas939093amritas
aortas65417783aor_tas
argalas84011093argalas
arhats9312973arhat_s
aristas7413523aristas
armadas1038173armadas
arracks1387733arracks
arras55626133arr__as
arrases71214543arrases
arrayal1055843arrayal
arrayals1154483arrayals
arrays95311683arra_ys
arrobas969213arrobas
asramas938303asramas
balatas9311833balatas
barytas12378283barytas
berates94126873berates
berettas1046733berettas
berrettas1143853berrettas
borates94823013borates
brats75336013_brat_s
bravas114913323_bravas
brazas175812433_brazas
breaths124411183breaths
carates95630613carates
carats85929023carat_s
caritas93316953caritas
cerates95428253cerates
crates85736063_crates
creates95225203creates
curaras93911953curaras
curates95323833curates
derates84028893derates
derats74625063derat_s
dramas95814653_dramas
drats66628373_drat_s
earths95014593ear_ths
eats47054873e__at_s
ecartes94212563ecartes
eclats8313033eclat_s
egrets72712243egret_s
elates65032363e_lates
eluates72014683eluates
emeritas1046433emeritas
emirates101214853emirates
enates64026423e_nates
enrages83114853enrages
equates162012323equates
eras45441503e_r__as
erases64425403e_rases
erects84116183erect_s
ergate7315143ergat_e
ergots74512373ergot_s
ericas8315463e_ricas
errable9312183errable
errancy1256363errancy
errand758793erra_nd
errant6618733erra_nt
errantly1175793errantly
errantry11113463errantry
erratical1146903erratical
errors63311313err_ors
errs45622533err___s
ersatz1536653ersat_z
ersatzes1743073ersatzes
eructs83610793eruct_s
erupts8348903erupt_s
estates74520183estates
etas46432273e___tas
exactas16336433exactas
expats1537683expat_s
eyras84715923eyr__as
fermata12278143fermata_
ferrate103014043ferrat_e
ferrets103111393ferret_s
ferrites112312833ferrites
fracas11311993_fracas
frats86829673_frat_s
gramas94317203_gramas
grates75429893_grates
gratis74819243_gratis
greats76318393great_s
groats74816653groat_s
gyrates113610263gyrates
jurats134213203jurat_s
karates115617473karates
karats106420493karat_s
katas95922093__katas
kerrias11289513kerr_ias
korats105416063korat_s
kurtas10349883kur_tas
maracas11313773maracas
marantas10310023marantas
narrates8312763narrates
orates64328613_orates
overrates12414623overrates
perorates11417023perorates
pinatas93711503pinatas
piranas9912603piranas
pirates93020333pirates
pirayas1277483pirayas
prates84633163_prates
prats76333393_prat_s
prorates10418073prorates
puranas9712643puranas
ragas65326063__ragas
raias54631123__raias
raitas64417673_raitas
rajas127317723__rajas
ratal55025113__ratal
ratals64219583__ratals
ratan53722663__ratan
ratans63819373__ratans
rates55352013__rates
ratos55528763__ratos
rats46260373__rat_s
rayas85922053__rayas
reata54225393_reata_
rebates95123183rebates
rebatos92913113rebatos
recrates102420373recrates
redates83423873redates
regattas944473regattas
regrates92618403regrates
relates73731433relates
remates93827113remates
reracks132310533reracks
riata54618023_riata_
rotas54827723__rotas
ruanas6311263_ruanas
serenatas9145193serenatas
seriates82620673seriates
serranos857873serranos
serrate73017543serrat_e
serrated92513433serrated
sonatas7510293sonatas
sprats85819933sprat_s
strata63616283strata_
stratal72710603stratal
straths102711723straths
stratus73011733stratus
taramas9612703taramas
tarantas839193tarantas
terraces102712253terraces
terrains8410323terrains
terranes82514433terranes
terras63516973terr__as
terrases82111483terrases
terrets72913583terret_s
territs72714503territ_s
tortas64918253tor_tas
treats64821693treat_s
uprates93814863uprates
urates65027763_urates
veritas103012753veritas
verrucas1343923verrucas
wraths123810083_wraths
wreaths13338373wreaths

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.406440125.6
2DLD Change Limit1340271746.12321889.1
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.59227107.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.