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

186 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
litas5492377(None) 
ditas65923671ditas
limas75627631limas
liras56021981liras
litai55216361litai
lits46252491lit_s
lotas55926301lotas
pitas77427671pitas
agitas7310592agitas
aits46355532ait_s
alias55834602ali_as
aliyas93911802aliyas
antas55432032antas
betas75528762betas
bias64738162bi_as
bimas95521742bimas
biotas84313922biotas
bites75641172bites
bits66148162bit_s
bitts75022592bitts
blites84721212blites
botas75328782botas
cites74435582cites
dita56032522dita_
dites66339152dites
dits56450522dit_s
divas95418582divas
elites66027122elites
etas46432272_etas
fetas85624402fetas
fiats85324482fiats
fits76043462fit_s
flites95122442flites
flits85625222flit_s
flotas94013002flotas
getas65421482getas
gigas75415582gigas
gites65630182gites
gits55744592git_s
glias64618492gli_as
hits75545132hit_s
iotas54821112iotas
its35538832_it_s
jotas125717442jotas
katas95922092katas
kinas95626912kinas
kites95432542kites
kiths125814972kiths
kits86441762kit_s
kivas124614732kivas
lamas75532792lamas
las37281472l__as
laths86022402laths
lats45962702lat_s
lavas85422222lavas
leas45954182l_eas
lets47147942let_s
lianas63713382lianas
liar47229682li_ar
liars54723162liars
libras83711702libras
libs66732762li_bs
licks115325392licks
lidar6312722lidar
lidars7310782lidars
lidos65219882lidos
lids56336452li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
ligan67920282ligan
ligans76817732ligans
ligase7259912ligase
likes96231902likes
lilac7311072lilac
lilacs837482lilacs
lilos55821872lilos
lilts55822802lilts
lima65734132lima_
liman75921602liman
limans84816302limans
limbas105313202limbas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limpas105513082limpas
limps95522672limps
linac7315412linac
linacs8310812linacs
lines57054572lines
lingas75116562lingas
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lipa68425922lipa_
lipase8239102lipase
lips67141442li_ps
lira46928682lira_
lis37162272li__s
lisps76913902lisps
lists56628692lists
lit39377312lit__
litany939052litany
lite47054542lit_e
liter54736342liter
liters65429872liters
lithe84922012lithe
lithias1038822lithias
litho86513782litho
lithos94212552lithos
litmus836322litmus
litre55421462litre
litres65220392litres
litu47631562lit_u
lives86133192lives
lota47233502lota_
lotah85315852lotah
lotahs9479872lotahs
lotos54724632lotos
lots47652092lot_s
lotus55718062lotus
lumas75622912lumas
lunas55025012lunas
lutes55836662lutes
lyttas985072lyttas
micas96823052micas
minas75434112minas
mites75141802mites
mitis75425992mitis
mitts75523752mitts
nipas77116672nipas
nites55736342nites
nits45741642nit_s
pias66542552pi_as
picas94626522picas
pietas84516502pietas
pikas114218092pikas
pimas94725102pimas
pinas75434452pinas
pintas85021392pintas
pita65436432pita_
piths105817542piths
pits66348742pit_s
pittas86014522pittas
raitas64417672raitas
rias45540592ri_as
riatas63915082riatas
rites54442552rites
rotas54827722rotas
sikas94617022sikas
simas75727552simas
sitar54820542sitar
sitars65417592sitars
sites56045432sites
sits45050202sit_s
situs55019232situs
slits56128852slit_s
tas38477102__tas
titan53318172titan
titans63414912titans
titis56023812titis
tits46145032tit_s
utas45924952_utas
vigas94817882vigas
vinas85126342vinas
visas84317652visas
vistas94513272vistas
vita75828522vita_
vitae84217632vitae
vital84819672vital
vitals94514302vitals
vivas114815022vivas
witan83816502witan
witans93412932witans
wites85536962wites
wits76044872wit_s
zetas145018162zetas
zitis145815582zitis
zits136030292zit_s

Search took 3 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.1231452772.4
2DLD Change Limit538001861.90628226.7
3Display Results1861860.0632952.4
 (SQL Overall)1786911862.09285416.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.