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

244 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
errata63901(None) 
erratas736861erratas
ergate7315142ergate
errand758792errand
errant6618732errant
errants7410642errants
erratic9311122erratic
erratum944512erratum
ersatz1536652ersatz
fermata12278142fermata
ferrate103014042ferrate
reata54225392_reata
riata54618022_riata
serrate73017542serrate
strata63616282strata
aerate64830553aerate
albata839333albata
amrita8411133amrita
aorta55922573aor_ta
arcana8912583arcana
argala74712673argala
arhat8327093arhat_
arhats9312973arhats
arista6415293arista
armada938783armada
arrack121110253arrack
arrant6623253arrant
arras55626133arra_s
array86317143arra_y
arrayal1055843arrayal
arrays95311683arrays
arriba867683arriba
arroba898663arroba
asrama839193asrama
aurate64426473aurate
balata8614683balata
baryta114310293baryta
bemata10411693bemata
berate84729023berate
beretta938463beretta
berretta1044803berretta
borate85026153borate
brat66055543_brat_
brats75336013_brats
brava106414793_brava
braza165214253_braza
breath113916263breath
carat75048793carat_
carate84734003carate
carats85929023carats
cerate84829463cerate
cirrate92413493cirrate
crate76537403_crate
create85126383create
crista8311803crista
curara83712203curara
curate85226243curate
data56026653__data
derat65044083derat_
derate74531233derate
derats74625063derats
drama85117423_drama
drat56247833_drat_
drats66628373_drats
earth85023053ear_th
eat36989053e__at_
eath75735663e__ath
eats47054873e__ats
ecarte84313503ecarte
eclat7523603eclat_
eclats8313033eclats
edemata1046003edemata
egesta7428653egesta
egret63327313egret_
egrets72712243egrets
ejecta15337393ejecta
elate55335883e_late
eluate62315433eluate
emerita938713emerita
emirate91015833emirate
enate54428153e_nate
enemata948023enemata
enrage72715073enrage
enrapt8313013enrapt
equate152012463equate
era35741503e_r__a
eras45441503e_ra_s
erase54925493e_rase
erect74129333erect_
erects84116183erects
ergates8314493ergates
ergot65422893ergot_
ergots74512373ergots
erica7316543e_rica
err35626533err___
errable9312183errable
errancy1256363errancy
errands847603errands
errantly1175793errantly
errantry11113463errantry
erratical1146903erratical
erratics1046983erratics
erred65915673err_ed
erring73816483erring
error53712233err_or
errors63311313errors
errs45622533err__s
erst47436433e_rst_
eruct74022353eruct_
eructs83610793eructs
erupt74220063erupt_
erupts8348903erupts
estate64719763estate
eta35834193e___ta
eureka1034483eureka
exacta15337393exacta
excreta1674623excreta
expat14313813expat_
expats1537683expats
eyra76217553eyr__a
eyras84715923eyra_s
fermatas13246223fermatas
fermate122813003fermate
ferrates113013423ferrates
ferret93021173ferret_
ferrets103111393ferrets
ferrety13287013ferrety
ferrite103312753ferrite
frat75648543_frat_
frats86829673_frats
frusta937453frusta
grama85620283_grama
grana65722093_grana
grat55651283_grat_
grate64932883_grate
great66034243great_
greats76318393greats
groat65531973groat_
groats74816653groats
gyrate104912523gyrate
hereat93527413hereat_
irate55627983_irate
jurat124829323jurat_
jurats134213203jurats
karat96837603karat_
karate105320923karate
karats106420493karats
kata85626033__kata
kerria10339923kerr_ia
korat94934433korat_
korats105416063korats
kurta95113913kur_ta
lemmata1144673lemmata
lyrate94112103lyrate
maraca10314153maraca
maranta9311693maranta
narrate7313493narrate
nervate1039533nervate
orate55133303_orate
organa789213organa
ornate6315143ornate
orra46120723orr__a
overrate11615693overrate
perorate10417923perorate
pinata83817223pinata
pirana8713263pirana
pirate82322883pirate
piraya1167713piraya
prat65952043_prat_
prate75135983_prate
prats76333393_prats
prorate9418733prorate
pruta7314243_pruta
purana8712933purana
raga55930813__raga
raia46638383__raia
raita54623073_raita
raja117918683__raja
rat37892743__rat_
ratal55025113__ratal
ratan53722663__ratan
rate45458763__rate
rath76037663__rath
rato45436973__rato
rats46260373__rats
raya75224823__raya
reatas64021013_reatas
rebate84424113rebate
rebato83714683rebato
recrate92621663recrate
recta74220263_recta
redate74124683redate
regatta835963regatta
regmata1036193regmata
regrate82618663regrate
relate64033633relate
remate84428683remate
rerack122513163rerack
reran57329103rera_n
resat55139683resat_
rhyta1135083_rhyta
riatas63915093_riatas
rota45834343__rota
ruana5312423_ruana
scrota8310203scrota
serenata8197673serenata
seriate73722473seriate
serrano768463serrano
serrated92513433serrated
serrates82617023serrates
somata8312383somata
sonata6313223sonata
sorta57125413sor_ta
sprat76635973sprat_
sprats85819933sprats
stratal72710603stratal
stratas73013583stratas
strath93216373strath
strati63518903strati
striata7379953striata
tarama8412733tarama
ternate7415483ternate
terra54419673terr__a
terrace93311843terrace
terrae62915213terra_e
terrain7410853terrain
terrane72814233terrane
terraria847023terraria
terras63516973terra_s
terret63425623terret_
terrets72913583terrets
territ63421383territ_
territs72714503territs
torta55925353tor_ta
treat56240353treat_
treats64821693treats
treaty94414353treaty
trymata1244223trymata
uprate83916543uprate
urate55432163_urate
verruca1243713verruca
wrath115715873_wrath
wreath124111193wreath
yurta86014253yur_ta

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.390458182.1
2DLD Change Limit1127162445.23321539.5
3Display Results2442440.0803050.0
 (SQL Overall)1786912445.70331332.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.