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

201 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
posada93716(None) 
posadas1037191posadas
panada94113052panada
pesade9311102pesade
pomade113611332pomade
posed85828412posed_
tostada894952tostada
aggada955223aggada
armada938783armada
asana5315483_asana
casaba1079263casaba
casava1157873casava
cicada1136413cicada
coala77521123co_ala
coda77029343co__da
comade114415323comade
costa75523733cos_ta
dada66422443__dada
dorado838813dorado
dorsad8408973dorsad_
dosage82810003dosage
dosed76626913dosed_
fossa85812633fos_sa
gelada837623gelada
goad66830983go_ad_
goads77022853go_ads
gonad75216053gonad_
gonadal956523gonadal
gonads84511733gonads
hamada1239923hamada
hodad10311353hodad_
hodads1147963hodads
honda9414983ho_nda
hosanna1044063hosanna
hosed95830983hosed_
hosta85917833hos_ta
koala95112213ko_ala
load56730603lo_ad_
loads65323373lo_ads
masala8311813masala
misadd1037163misadd
monad85519473monad_
monadal1047893monadal
monads94515303monads
monarda1046613monarda
mosaic10311143mosaic
mousaka1343173mousaka
nada58022903__nada
nomad86016183nomad_
nomads94711603nomads
nosed65524553nosed_
noyade1036423noyade
oda48133043_o__da
omasa749483_omasa
orad56031693_orad_
osar46820953_osa_r
ossa43714163_os_sa
ossia53710403_ossia
ostia52315583_ostia
paca85132243p__aca
pad68057323p__ad_
padi76331783p__adi
pads76742953p__ads
pagoda10487873pagoda
paisana94010223paisana
pajama17317653pajama
palapa10310673palapa
panadas103312213panadas
panama104213353panama
panda85022613p_anda
papa85827143p__apa
papadam1486913papadam
papaya1337503papaya
para65242173p__ara
parade94720643parade
pasha105417183pas_ha
passade1039233passade
passado1037053passado
pasta76624533pas_ta
pataca10311193pataca
pesades10310903pesades
peseta8310573peseta
pesewa1135543pesewa
piasaba1144193piasaba
piasava1243883piasava
picara10311903picara
pinata83817223pinata
pintada1096083pintada
pirana8713263pirana
piraya1167713piraya
pitaya1186603pitaya
plasma103810913plasma
playa105812943p_laya
plaza164311063p_laza
plead85818463plead_
pleads94613953pleads
poach124917863po_ach
pod66351483po__d_
podagra1143603podagra
podia8415283po_dia
pods76540153po__ds
poind84217913poind_
poinds93511143poinds
poised94918473poised_
poisha1135723poisha
poked125425393poked_
polar75623453pola_r
polars84419353polars
poled84934843poled_
polka11310413po_lka
pomace123111913pomace
pomaded13377863pomaded
pomades123711733pomades
pond75530493po_nd_
ponds85323403po_nds
pood75934323po_od_
poods85124753po_ods
pooed85226243pooed_
poppa8409893po_ppa
pored85234513pored_
posable112212783posable
pose66441733pos__e
poser75128773pos_er
posers84223973posers
poses74642763pos_es
poseur8419403poseur
posh95427323pos__h
posher115018163posher
poshly1437723poshly
posies84431433posies
posing93922643posing
posit75833333pos_it
posits85718713posits
posole8314223posole
posse74722273pos_se
posses85128803posses
posset84923253posset
possum1057953possum
post67953363pos__t
postage103214853postage
postal84317533postal
postals93716373postals
postanal1048053postanal
postbag1245223postbag
postcava15134033postcava
postdate1139653postdate
postdoc1245263postdoc
posted93722493posted
poster84129173poster
postie84123963postie
postin83521033postin
postman112410043postman
postop10511943postop
posts75228783pos_ts
posttax1645533posttax
postwar1236903postwar
posy96028423pos__y
potage92715903potage
potash1138273potash
potato8513433potato
pound84417863pound_
poundal1036403poundal
pounds93714383pounds
poxed154817863poxed_
prosaic11311163prosaic
prosed94921093prosed_
prosody1336433prosody
prosoma11310223prosoma
psalm949273p_salm
psoae74411623psoa_e
psoai7469923psoa_i
psoas75012983psoa_s
purana8712933purana
purda82914693p_urda
pyjama20303483pyjama
ramada9310183ramada
reseda739703reseda
road56332113ro_ad_
roads66523623ro_ads
rosacea944713rosacea
rosaria749253rosaria
rosary92810353rosary
rosed65930343rosed_
rostra6310933rostra
sad47459203__sad_
sade55544473__sade
sadi55834643__sadi
saga55331173__saga
soda56329383__soda
somata8312383somata
sonata6313223sonata
toad55830183to_ad_
toads65621073to_ads
toady96814343to_ady
torsade837593torsade
tostadas994523tostadas
tostado895953tostado
tsade64311123_tsade
tsadi6379913_tsadi
woad85523943wo_ad_
woads94818443wo_ads

Search took 5 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.1401276364.3
2DLD Change Limit1127162014.72023880.5
3Display Results2012010.0633190.5
 (SQL Overall)1786912014.92336297.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.