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

284 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
valuta93874(None) 
valutas1036531valutas
alula5317092_alula
balata8614672balata
flauta937822flauta
halutz1868852halutz
makuta1236392makuta
salute64418022salute
taluka10426772taluka
vacua10510462vacu_a
valet84337872valet_
valets93715622valets
valuate102512732valuate
value85719092valu_e
valued104011152valued
valuer93911442valuer
values94314942values
valvula1343252valvula
vault85823762vault_
vaults94511672vaults
vaulty12388442vaulty
volta85215622vol_ta
volute93912762volute
abut66834953_abut_
abuts75417073_abuts
aceta74017353_aceta
acta69524803_a_cta
acute74720363_acute
adyta936853_adyta
agita6315423_agita
ajuga1335883_ajuga
ala312463603_al__a
alate55340323_alate
alba68328333_al_ba
albata839333_albata
alfa77624273_al_fa
alga57927603_al_ga
alit46155693_alit_
aliya83713483_aliya
alma66333023_al_ma
aloha8513613_aloha
alpha1049653_alpha
alt36467963_al_t_
altar55520643_al_tar
alto47831263_al_to
alts46639903_al_ts
alulae6312743_alulae
alular6311353_alular
alum65227613_alu_m
alumna857343_alumna
alums75720603_alums
anta46839583_a_nta
aorta55922573_aorta
aqua132813963_aqu_a
aura45836253_a_ura
auto47432083_a_uto
bacula103112673bacula
balatas9311833balatas
balboa10389963balboa
ballute938543ballute
balsa77920413bal_sa
baryta114310293baryta
beluga936233beluga
calesa8412473calesa
calla74827073cal_la
canula8312963canula
capita102913773capita
caput9823973caput_
casita82913703casita
chalupa1444473chalupa
chalutz2195083chalutz
daleth1038633daleth
data56026653da__ta
datura738023datura
daut56443563da_ut_
dauts67822243da_uts
delta66117773del_ta
dilute72911803dilute
elute54822573_elute
evaluate11287793evaluate
evolute1045683evolute
facula112912233facula
fajita1635923fajita
fault85428313fault_
faults94513553faults
faulty12429363faulty
fauna84816513fa_una
flautas1036153flautas
flota85315643_flota
flute86823753_flute
fluty114415643_fluty
gala55635163gal__a
galatea839943galatea
galea64722933gal_ea
galena74911093galena
galleta8399643galleta
gamut8322983gamut_
gamuts958783gamuts
gault65128483gault_
gaults74112783gaults
glut56331293_glut_
glute66020903_glute
gluts66120133_gluts
halala94715093halala
halite93624233halite
halloa94918123halloa
halma108219253hal_ma
halt76056303hal_t_
halts85230103hal_ts
halva115414433hal_va
haut75949733ha_ut_
haute89521613ha_ute
kahuna1394103kahuna
kalmia1238893kalmia
kalpa114512193kal_pa
kaput11717063kaput_
kaputt1268003kaputt
kata85626023ka__ta
klutz1868853_klutz
lacuna8118123lacuna
laguna7127223laguna
laura54116203la_ura
likuta1034213likuta
lota47233503__lota
luma65527523__luma
luna46229853__luna
lute46341013__lute
lutea54819073__lutea
lutz136826323__lutz
macula103013673macula
malate84624553malate
maloti8313193maloti
malt66254803mal_t_
maltha1137503maltha
malts76331753mal_ts
malty106721703mal_ty
manta75629903ma_nta
mantua84412023mantua
maut65448443ma_ut_
mauts75927193ma_uts
mazuma1935603mazuma
muleta839233muleta
nala46930393nal__a
ovality1377593ovality
palapa10310673palapa
palatal9310153palatal
palate84226783palate
palea75028663pal_ea
palet74650803palet_
palets85122313palets
pallia83015593pallia
paludal1035683paludal
papula103011113papula
parura8310583parura
pasta76624533pa_sta
pelota8612833pelota
pruta7314243_pruta
radula749313radula
raita54623073ra_ita
ranula6311813ranula
salina64221123salina
saliva93110743saliva
salpa75018353sal_pa
salsa56718923sal_sa
salt45758523sal_t_
salts55431883sal_ts
salty85524383sal_ty
saluki1036203saluki
salutary1145113salutary
saluted84511703saluted
saluter73512453saluter
salutes73716253salutes
salvia93310753salvia
sancta839833sancta
sapota8310203sapota
sault55834963sault_
saults65816173saults
sauna54117553sa_una
saute55028083sa_ute
scuta75815753_scuta
slut45040593_slut_
sluts54523983_sluts
solute64016663solute
sputa74612963_sputa
tala45938053tal__a
taluk94812873talu_k
talukas11316213talukas
taluks10418283taluks
talus55423263talu_s
tapeta8310693tapeta
taut47048963ta_ut_
tauts56125513ta_uts
uta37425583___uta
vacate11314553vacate
vacuity1545763vacuity
vacuum1334833vacuum
vagina102710933vagina
vague96513113vagu_e
vaguer10448443vaguer
vagus96713813vagu_s
vale74937343val__e
vales85434263val_es
valeted1139013valeted
valgus1047103valgus
valid94618383val_id
valine94623093valine
valise92917643valise
valkyr1632403valkyr
vallate103016563vallate
valley124311603valley
valonia1048303valonia
valor83614893val_or
valors93413773valors
valour93010373valour
valours10248733valours
valse85117523val_se
valses94514613valses
valuated12239203valuated
valuates112811193valuates
valuator1196723valuator
valuers10328943valuers
valuing11298843valuing
valval12398863valval
valvar12388653valvar
valvate133710813valvate
valve114515933val_ve
valved136711043valved
valves124113783valves
valvulae1442723valvulae
valvular1443463valvular
valvule1343663valvule
vanda94515923va_nda
vanity12311933vanity
vara75530883va__ra
varia85824203va_ria
varlet9423503varlet_
varlets10411573varlets
varna84516173va_rna
varus85921183varu_s
vasa76522973va__sa
vascula1245853vascula
vast75045123va_st_
vasts86423773va_sts
vasty116215923va_sty
vat67863453va__t_
vats76841743va__ts
vatu76524333va__tu
vatus86114643vatu_s
vau66840873va_u__
vaulted11307193vaulted
vaulter10257713vaulter
vaunt85925313va_unt
vaunts95212623vaunts
vaunty12409063vaunty
vaus75928923va_u_s
vela75725543vel__a
velate93720143velate
veldt94819863veldt_
veldts10417753veldts
veloute1037733veloute
velum10713383velu_m
velure939773velure
vesta86618303v_esta
vicuna11115903vicuna
villa85321233vil_la
vista85416603v_ista
vita75828523v__ita
vitta85015173v_itta
volt76439533vol_t_
volte85321303vol_te
volti84915963vol_ti
volts85421293vol_ts
volume11358273volume
voluted11297943voluted
volutes102710983volutes
volutin1098093volutin
volva11399003vol_va
vulva11448803vul_va
walla85321033wal_la
walnut939433walnut_
walnuts1033843walnuts
waltz17615473wal_tz
yakuza2261873yakuza
yautia937243ya_utia

Search took 9 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.1261418182.5
2DLD Change Limit1127162847.93614203.1
3Display Results2842840.0763736.8
 (SQL Overall)1786912848.13821957.6
 
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.