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

207 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
asea4632718(None) 
area45843391area
sea36161291_sea
aa219179952a__a
aba512850952a_ba
abba810522652abba
abeam9316532abeam
abed79734132abed
abet610547942abet
ace59656832ace_
aced79540882aced
aces67645092aces
aceta74017352aceta
acta69524802acta
ae212590292a_e_
aga410447232a_ga
age47154332age_
aged67334252aged
agee56241492agee
ager55935842ager
ages55844592ages
agha87417302agha
agma77623262agma
aha611246642a_ha
ahead96817052ahead
ahed89536252ahed
ahem97225362ahem
ajee115928232ajee
akee85936812akee
akela9311342akela
ala312463602a_la
alae45643752alae
alba68328332alba
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
ales47067102ales
alfa77624272alfa
alga57927602alga
alma66333022alma
ama510853302a_ma
ameba9312382ameba
amen66733152amen
amia66836902amia
ana39559822a_na
ane37866942ane_
anear55420322anear
anes45255932anes
anew76623132anew
anga56831352anga
anna45529012anna
anoa45634472anoa
ansa45927772ansa
ansae55720972ansae
anta46839582anta
ape57251182ape_
apeak115513452apeak
aped78538152aped
aper66336232aper
apes66047432apes
apex137220212apex
apnea73413412apnea
apse67725382apse_
apses76823912apses
aqua132813962aqua
are37874572are_
areae55229742areae
areal55928732areal
areas55935772areas
areca75618632areca
arena55323812arena
arepa75615562arepa
ares45871022ares
aria46245422aria
arse46539272arse_
arses55733872arses
as211083072as__
asana5315482asana
asci66519142asci
ash67944602as_h
ashed97829772ashed
ashen87818672ashen
ashes86230612ashes
ashy107717352ashy
ask77130702as_k
asked106919312asked
asker96418782asker
askew12529412askew
asks85721212asks
asp57235342as_p
aspen75216092aspen
asper75520432asper
asps65622092asps
ass37844062as_s
assai5711542assai
assay8710282assay
asses55629282asses
asset55932262asset
aster55434892aster
asyla839332asyla
ate37059242ate_
ates45047922ates
atma68121772atma
aura45836252aura
ava610139322a_va
ave67748702ave_
aver75931882aver
aves76142602aves
awa611939672a_wa
awe67746622awe_
awed88436032awed
awee76336642awee
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axes117337852axes
aye67151762aye_
ayes76543512ayes
base64847022base_
based85331582based
baser74828922baser
bases75644352bases
casa65630862cas_a
case65848082case_
cased86032412cased
cases75048382cases
ease45042332ease_
eased65430402eased
easel54521112easel
eases56041612eases
eses45336102eses
flea75628492flea
galea64722932galea
gases65633992gases
idea59122772idea
ilea45931462ilea
isba61310882isba
kasha124710722kasha
kea76540912_kea
lase46148512lase_
lased65132342lased
laser54633322laser
lases54944762lases
lea37660182_lea
masa65034712mas_a
maser75029972maser
massa75518922massa
mesa67025482mesa
nausea637312nausea
oases55330982oases
odea56224572odea
olea46532722olea
ose38147342ose_
oses46641512oses
ossa43714162ossa
palea75028662palea
pase65346862pase_
paseo77022512paseo
pases75346502pases
pasha105417182pasha
pasta76624532pasta
pea56657242_pea
plea66830602plea
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
rhea75017432rhea
sae38365182sae_
saga55331172saga
seal45654372_seal
seam66645972_seam
sear47353842_sear
seas45755272_seas
seat47575562_seat
sec55945322_sec
see35772262_see
seg45544882_seg
sei36048932_sei
sel38253322_sel
sen36058522_sen
ser36752402_ser
sera46141392_sera
set36681252_set
seta45637312_seta
sew66247262_sew
sex107043222_sex
sha69837782_sha
shea76031572shea
ska76925862_ska
spa55730812_spa
tea37353322_tea
toea46732332toea
urea46528052urea
use36835162use_
used55722822used
user45023002user
uses44931112uses
usnea539392usnea
uvea74712652uvea
vasa76522972vas_a
vase75629652vase_
vases84626262vases
yea66445752_yea
zoea137118422zoea

Search took 2 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 Filter178691298720.0931921408.6
2DLD Change Limit298722070.89333451.3
3Display Results2072070.0434814.0
 (SQL Overall)1786912071.029173655.0
 
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.