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 “tajes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

300 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
tajes12492069(None) 
hajes155420941hajes
rajes125022781rajes
tabes76033921tabes
taces76237801taces
takes94437791takes
tales55451371tales
tames75242011tames
tapes75838601tapes
tares57456561tares
tates55444981tates
taxes124730821taxes
aces67645092_aces
ages55844592_ages
ajee115928232_ajee
ales47067102_ales
anes45255932_anes
apes66047432_apes
ares45871022_ares
ates45047922_ates
aves76142602_aves
awes76037552_awes
axes117337852_axes
ayes76543512_ayes
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bates75846342bates
cades85440732cades
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cases75048382cases
cates75951872cates
caves105639702caves
daces85030682daces
dales66439742dales
dames85435852dames
dares66146702dares
dates65639152dates
dazes155024142dazes
eases56041612eases
eaves85231992eaves
etapes85415292etapes
faces106439432faces
fades94932862fades
fakes126032482fakes
fames105735922fames
fanes84639892fanes
fares85852872fares
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
gaes56348032ga_es
gages74529972gages
gales65442482gales
games86238552games
gapes86030822gapes
gases65633992gases
gates65939502gates
gazes155425912gazes
hades96035112hades
hadjes175210402hadjes
haes77651022ha_es
hajis156716272hajis
hajjes15485242hajjes
hakes126034302hakes
hales85449842hales
hames106138702hames
hares86255542hares
hates86742572hates
haves116034872haves
hazes174928322hazes
jades135222112jades
jakes165023642jakes
janes124928122janes
japes146322822japes
kaes85734062ka_es
kales95730982kales
kames115024692kames
kanes95529372kanes
laces76141762laces
lades65141272lades
lakes95737652lakes
lames75445542lames
lanes54946792lanes
lares54852632lares
lases54944762lases
laves86039152laves
laxes125430092laxes
lazes145129572lazes
mabes96331532mabes
maces97139962maces
maes66948392ma_es
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
mares76457632mares
mates75251362mates
maxes145629532maxes
mazes165632172mazes
nabes75427092nabes
names74833362names
napes74828462napes
nares55544152nares
nates55238332nates
naves87030382naves
oases55330982oases
oaves84925612oaves
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
pares77164482pares
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
races74943242races
rages64539442rages
rajas127317722rajas
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
sabes76437462sabes
sades65239892sades
safes85226722safes
sages65339062sages
sakes95540752sakes
sales56055592sales
sanes55649072sanes
sates54949322sates
saves85838632saves
saxes125229342saxes
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
taber73825822taber
tabers84621572tabers
tables84524882tables
tabs66842982ta_bs
tabus74820922tabus
tace65342512tace_
tacet75840022tacet
taches114224172taches
tachs105820932tachs
tacks115430132tacks
tacos77023552tacos
tacts76524122tacts
tads57143942ta_ds
tae38267052ta_e_
tael46030712ta_el
taels56822072taels
tags55545232ta_gs
tahrs85412332tahrs
tails55634192tails
tains54936322tains
taj106442192taj__
takas95520682takas
take84739262take_
taken94819142taken
taker95229002taker
takers103923742takers
talas55935892talas
talcs74817182talcs
tale46154162tale_
taler56034862taler
talers64628142talers
talks94322692talks
talls55133432talls
talus55423262talus
tame66343662tame_
tamed85528512tamed
tamer75230102tamer
tamers84224032tamers
tamest85721292tamest
tamis76728722tamis
tamps95524082tamps
tams67247932ta_ms
tangs65028342tangs
tanks94624732tanks
tans46154812ta_ns
taos45541002ta_os
tapas74627712tapas
tape64538142tape_
taped85327422taped
taper74829772taper
tapers84025812tapers
tapis75028862tapis
taps66050672ta_ps
tare45957622tare_
tared69340052tared
targes74524592targes
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tarres64723042tarres
tars46763952ta_rs
tarts57242022tarts
tas38477102ta__s
tasks94917582tasks
tass45640572ta_ss
tasse54821842tasse
tasses64826762tasses
tastes64126422tastes
tate44748602tate_
tater54138612tater
taters64932192taters
tats46858132ta_ts
taupes8212672taupes
taus46342732ta_us
tauts56125512tauts
tavs75630972ta_vs
tawed95926192tawed
tawer85223442tawer
tawers94118602tawers
taws75641592ta_ws
tawse85616502tawse
tawses94913192tawses
taxed135620292taxed
taxer125019362taxer
taxers134015282taxers
taxies135817332taxies
taxis126821972taxis
taxus125512482taxus
teases65426272teases
tees45353582t_ees
teles54536002teles
thanes94918982thanes
tides64830152tides
ties45248312t_ies
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
toes46956442t_oes
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
traces85329932traces
trades75724492trades
trapes85024462trapes
traves94222742traves
trees55835762trees
tres46542902t_res
tries55742812tries
trues54925322trues
tsades74310992tsades
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tuxes124316042tuxes
twaes86513662twaes
tyees86019452tyees
tyes76433372t_yes
tykes125817062tykes
tynes85920302tynes
types105721062types
tyres84725232tyres
vales85434262vales
vanes85130972vanes
vases84626262vases
wades95634142wades
waes76048602wa_es
wages95330932wages
wakes126633652wakes
wales86142832wales
wames106432802wames
wanes85040882wanes
wares88250582wares
waves115633922waves
waxes155825502waxes
zaxes215113822zaxes

Search took 4 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 Filter178691538000.1731032896.0
2DLD Change Limit538003003.18616886.4
3Display Results3003000.1262381.0
 (SQL Overall)1786913003.48551274.3
 
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.